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?

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.



"Matt" wrote:

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?

thanks Barb...good idea....

"Barb Reinhardt" wrote:

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.



"Matt" wrote:

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?