PIVOT TABLE GRAND TOTALS USE IN OTHER CALCULATIONS

[georgegv]

Hi,

i am trying to use the pivot table grand total in other calculations in order to calculate contributions.

In order for me to have calculate the Grand total I have made use of the following syntax:

1. aggr(count(PracticeNo),ScriptPeriod) - A calculated ROW     [ Works  perfectly]

so now I have to use a Calculated Row with a measure to create another measure, hope this makes sense

Regards