Using IF function together with GETPIVOTDATA

Originally Posted by Domski

Hi,

If you pop an = in a spare cell outside the pivot table and then select the total that you want Excel will display the GETPIVOTDATA formula that is required for that for you.

Dom

At first I didn't understand what you meant because when I did what you told, it just shows =A6 for example. I went to PivotTable Tools chose Options and checked the "Generate GetPivotData" so now it is working.

Thank you so much for the help.

Regards, Kagesen