How to pull Grand Total from Pivot table using Getpivotdata

[Jagdev Singh]

Hi Experts

I am trying to pull Grand total from pivot table with Getpivotdata function. I am able to pull my data wuth year wise with the following formula--

=IFERROR(GETPIVOTDATA("Total Incurred",$P$4,"Policy Year",I$4,"Cause",$B5),0)

Since Grand total in not part of the Policy year column I tried to change it, but failed to pull the total

=IFERROR(GETPIVOTDATA("Total Incurred",$P$4,"Grand Total",J$4,"Cause",$B5),0)

Please guide me with this.

Regards,
JD

 

[Faseeh]

Please upload sample file that will help you get quicker responses.

 

[Jagdev Singh]

Hi Faseeh

I created a dummy sample file, please find it attached.

Regards,
JD

 

[Jagdev Singh]

Hi Faseeh,

I managed to get the formula word - =GETPIVOTDATA("Incu",$A$3,"Name",$A5)

Regards,
JD