How can I get the sum of all cells in a column using a pivot table and a complex expression?
The expression is designed to adjust a physician's work relative value units (wRVUs) to account for money they brought in through contracts and the amount of time they spend on clinical tasks. Essentially, we want to know how many wRVUs a given physician would earn if they were working in the clinic full time and all year so we can help in reviewing their performance.
Sadly, this expression has to be in a pivot table so getting the total of this expression's results to appear in the subtotal rows is proving too difficult for me. I am going to try and write out the full expression. Keep in mind I am excluding all the set analysis, so please bear with me while i try to generalize it all:
//This variable is represents how much of the fiscal year has been completed.
Inverse_Year_Completion = 12/11
//This is the variable we are using to convert Contract money into wRVUs. I didn't create this, so I am not sure why this is used, but