GetPivot formula
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Tables -Calculating Net Sales
=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.
1 answers ( 0 marked as helpful)
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