Getting different (GETPIVOTDATA) Formula
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
I get this function when I am starting to populate the cells Which make it difficult to edit the formula
=GETPIVOTDATA("[Measures].[Sum of Volume]",Sheet3!$A$3,"[Range].[Year]","[Range].[Year].&[2015]","[Range].[Month]","[Range].[Month].&[01]","[Range].[Brand]","[Range].[Brand].&[Buratino]")
When I trying to replace the year argument with the cell number it gives me #REF and when deleting the month argument. But When I remove the argumet of brand It work.
4 answers ( 0 marked as helpful)
Hi Abdelrahman,
Good to hear from you.
Could you share a screenshot of the construction of your pivot table, please?
Best,
Ned
Submit an answer
related questions
Hi, why i get error on Gross Sale Income formula? i can't figure it out. hope someone will give ans.