SOLVED

Data From Pivot Table not displaying on Dashboard

Copper Contributor

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. 

Dashboard-Screenshot.JPGData-Table_Screenshot.JPGPivot_Table-Screenshot.JPG

1 Reply
best response confirmed by Dwight-MEP (Copper Contributor)
Solution
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 :)
1 best response

Accepted Solutions
best response confirmed by Dwight-MEP (Copper Contributor)
Solution
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 :)

View solution in original post