Forum Discussion
Solved
Data From Pivot Table not displaying on Dashboard
Good day,
I'm working on a dashboard using data from excel and pivot table.
I have tried to link the data from the pivot table to the dashboard using the ="othertable"!$Data$Cell formula.
For some reason the data is not displaying in my shape on the dashboard.
I've Included screenshots of the tables and data set information
Thanks in advance for any assistance.
- So I finally Figured it out!!!
It seems that the Pivot Table actually has to be named Pivot Table or the data will not map from it!!
SMH MS Really???
I wouldn't have thought the name of the Pivot Table would matter as long as there's data in the cell you're mapping to.
But at least I figured it out 🙂
- So I finally Figured it out!!!
It seems that the Pivot Table actually has to be named Pivot Table or the data will not map from it!!
SMH MS Really???
I wouldn't have thought the name of the Pivot Table would matter as long as there's data in the cell you're mapping to.
But at least I figured it out 🙂
