GETPIVOTDATA help

M

Matt

I'm trying to create a conditional field for getting pivot data - for
example, if it is week 1, it will grab the pivot data for week 1 and the
specfic data of interest. I also want to get the grand total amount, but it
doesn't seem to be working when I try to pull that value even though the
condition is met - how is it referenced in get pivot function?
 
B

Barb Reinhardt

Why not try doing something manual and then change what you get? In some
cell outside of the pivot table enter = and select the cell of interest
within the PIVOT table and you should get the GETPIVOTTABLE function. You
can then change the info of interest. That's usually how I do it.
 
M

Matt

thanks Barb...good idea....

Barb Reinhardt said:
Why not try doing something manual and then change what you get? In some
cell outside of the pivot table enter = and select the cell of interest
within the PIVOT table and you should get the GETPIVOTTABLE function. You
can then change the info of interest. That's usually how I do it.
Click to expand...
 
Top