getpivotdata with multiple grand totals
Posted on 2013-09-17
I have a pivot table with 4 items being totaled. There is 1 sum, and 4 averages being calculated in the pivot.
How do I use a getpivotdata formula to specify only the sum? I guess, since I have multiple totals, the Getpivotdata isn't working for me...as if it doesn't know which to supply me.