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
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
Try
[vba]
=GETPIVOTDATA(A1,"Grand Total")
[/vba]
where A1 is where the pivot table starts.
Regards,
Barrie,
that gives a #Ref...
A1 is the top row of the column ?
Colin
A1 is where the pivot table is (top left corner).
Does this help?
Yes !!!
Many Thanks Barrie !
Colin
Don’t have an account yet? Register yourself now and be a part of our community!