Hello Friend;
Good Morning;
How are you ?
I like to practice GETPIVOTDATA Function as much as possible. but again, I am getting #REF! error. Worksheet is attached.
Please advised me, what I did wrong? and for future, What I have to enter in data field, field1, Item 1, Field2, Item 2. Please explain me in
detail.
Thank you very much.
Have a great day.
Hello Mitul,
As I wrote in a previous reply, you need to check the table header names in the Pivot Table.
Your formula is: =GETPIVOTDATA("Order Amount Total";$C$8:$U$17;"Name";"Bromley";"YEAR"; 2011)
The table headers in your Pivot Table are:
Country
Salesperson
Order Date
OrderID
Units
Order Amount
Quarters
Years
So, remove Total so you have "Order Amount". Change Name to Salesperson and add an S in YEAR so you get "YEARS". You also have a space in front of 2011, so that needs to be removed to.
Your formula should now look like this: =GETPIVOTDATA("Order Amount";$C$8:$U$17;"Salesperson";"Bromley";"YEARS";2011)
Your formula is correct, you just reference with wrong table header names.
Br,
Anders
