Forum Discussion
GETPIVOTDATA function return error
Hi,
I am trying to make a dashboard with different charts taking information from pivot tables and connected to a slicer filter to have a coordinated view.
for the number in the filed I am trying to use Getpivotdata function because if I just put the connection to the cell when I make the filter the information are not correct
But when I connect the formula return me the following message
the dashboard is in a different sheet than the pivot (but also with the pivot in the same sheet is not working)
I don't understand what is missing 😞
thanks
Return GETPIVOTDAT result into any cell and for the shape use reference on that cell.
DR_74 You can't 'attach' a formula like that to a shape. consider entering the GETPIVOTDATA formula in a cell near the pivot table and out of view of your dashboard and reference that cell in the shape. Example below.
Riny_van_Eekelenand SergeiBaklan
thanks for the clarification, as you both suggested I have done a connection with a normal cell and is working.
As you know how to use the GETPIVOT formula, how can I add the "-" to don't have #REF! when the value is = 0?thank you very much for the help!
You may wrap it with IFERROR()
=IFERROR( GETPIVOTDATA(...), 0 )I assume you have #REF on filtered labels, for other ones GETPIVOTDATA() returns correct values.
