create calculated total in pivot table using value entered by user at runtime?

[Repent]

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?

chris

 

[SOS]

You would have to create the Pivot table query in VBA to do so, I believe.

 

[Repent]

Can this be done with just a regular select query? I don't necessarily have to have this piece on my pivot table query.

chris

 

[Repent]

got it figured out.