Forum Discussion
DR_74
Jan 17, 2024Copper Contributor
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 t...
Riny_van_Eekelen
Jan 17, 2024Platinum Contributor
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.