[Solved] Formulas: to show last cell on a pivot column

Colin Nicol · Sep 11th 2003

Evening !
I want a formula ....to sit two rows above a pivot table column (with sub-totals and grand total).....that will constantly show the value of the Grand Total ( whose position will change as the pivot table changes) .

Thanks

Colin

Barrie Davidson · Sep 11th 2003

Try
[vba]
=GETPIVOTDATA(A1,"Grand Total")
[/vba]
where A1 is where the pivot table starts.

Regards,

Colin Nicol · Sep 11th 2003

Barrie,

that gives a #Ref...
A1 is the top row of the column ?

Colin

Barrie Davidson · Sep 11th 2003

A1 is where the pivot table is (top left corner).

Does this help?

Colin Nicol · Sep 11th 2003

Yes !!!

Many Thanks Barrie !

Colin

[Solved] Formulas: to show last cell on a pivot column

Participate now!

Share