Last answered:

16 Nov 2023

Posted on:

11 Feb 2023

0

GetPivot formula

=IFERROR(GETPIVOTDATA("Sum of "&B16,pivot_financials!$A$3,"Month",C11,"Year",C12),0)

this formula is picking values from total sum of - volume, Gross sales etc and not from the column that was selected while entering the formula i.e sum of volume, gross sales etc. when I am searching the value that is obtained from Getpivot formula in Pivot Financial sheet those values are in Total Sum of volume and Gross sales columns of pivot table and not in Sum of Volume and gross sales column placed before the total columns in pivot table.

3 answers ( 0 marked as helpful)
Instructor
Posted on:

21 Feb 2023

0

Hi Himanshu, 

thanks for reaching out! Could you provide screenshots of the sheets mentioned and the values they hold, so that we can compare the values in both sheets. 

Thanks in advance!


Best, 

365 Eli

Posted on:

16 Nov 2023

0

Thank for reaching out 

Posted on:

16 Nov 2023

0

Thank you 

Submit an answer