• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Grand Total

V

Vpremakumar

New Member
I have to generate some additional calculation out of pivot table grand total, also I have report filter and with that reference row for each filter is keep changing, how write a formula so that my additional calculation always refer the grand total row based on the report filter values. Please help me.
 
Vpremakumar


You can either use a GETPIVOTDATA() function

=GETPIVOTDATA("Field Name",Top Left Adress of PT)


or


Use an Offset and lookup the Words "Grand Total" in the First Row and Column of the PT to get the locations

eg: =OFFSET(F4,MATCH("Grand Total",F5:F100,0),MATCH("Grand Total",G5:Z5,0))
 
Hi Vpremakumar,


If you are preparing a report out of pivot table you can use GETPIVOTDATA() to get to the total of it always.


If you are worried about the table expanding then you can turn it into a proper "Table" (format as Table) so Pivot will automatically adjust the new data just refresh it.


If i missed your question then please upload a sample file and elaborate your requirement! :)


Edit: Hui just replied you..


Regards,
 
You must log in or register to reply here.
Back
Top