Pivot Table Grand Total

[Tufail]

Hello,
How can I get Pivot Grande Total in some other cell ?
Righ now that's in cell L48, but as you know if more data come then this cell
would be changed to like L60 etc.etc

Thanks in advance.

 

[Roger Govier]

Hi

There is no way to move the position of the Grand Totals in a PT.
However, you could "cheat"
Assuming your Pivot Table starts in column A of the Sheet, Insert a new
column A and use the GetPivotData function to copy the Grand Total to this
cell.

For example in cell A5 you would have a formula something like
=GETPIVOTDATA("Hours",$B$3,"date",B5)

Your formula will be different, depending on the Field names in your PT.
Just type = in cell A5 (or your first row of data) and then point to the
Grand Total on that row and the formula will be inserted for you.
The final term in the expression, will be "fixed" and relative to only that
row.
Change it to a relative reference (like B5 above) and then copy down.

For more help on GetPivotData take a look at
http://www.contextures.com/xlPivot06.html

 

[Tufail]

hahaha"cheat" anyway it's working ! thank you very very much !