Get data from pivot table

[mitsiosevo8]

I have a pivot table (sheet name: PivotMonthly) for sum of acd calls and the months (from January 2011 until May 2020). I created new sheet and i want to add getpivot data from pivot table for all months and shows in specific cell. I have a timeline which is connected to pivot, when change month to return the data to specific cell i mentioned above. I have this formula but it doesn't work =GETPIVOTDATA(ACD CALLS,PivotMonthly!$A$3,"Sum of Info ACD CALLS"). Can you please assist?

 

[mamady]

Hi,

Unfortunately, I did not understand the issue exactly. However, have you tried instead of typing in the formula in the newly created sheet, to actually select the raw data again and create a new PivotTable?

Best Regards
M. Yusuf