Unanswered: create calculated total in pivot table using value entered by user at runtime?
I have a pivot table I'd like to add another calculated field to. This calculated field would be the result of a known value in a table, divided by a value added by the user when they run the pivot table query.
Currently the PT query runs and asks the user for beginning and ending calendar dates. I'd now like the PT query to also ask the user for a value, called "Employee Hours". The PT query would then run and display the results. The math in general terms would be: Productivity=LF Produced/Employee Hours.
Is it possible to create a PT query and at runtime, have it be able to ask the user to input a number, and then use that number to create a value to plug into the PT query?
I could also have this in a select query it doesn't necessarily have to be in my pivot table query. Can this be done in a select query? My user just needs the value and the employee hours part is the variable that needs to be entered at runtime.