=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.

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

Follow this topic

Himanshu Pant

Last answered:

21 Feb 2023

Posted on:

11 Feb 2023

GetPivot formula

in The Complete Data Visualization Course with Python, R, Tableau, and Excel / Dashboard in Excel – Tables -Calculating Net Sales

1 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

21 Feb 2023

GetPivot formula

Submit an answer

related questions