Data From Pivot Table not displaying on Dashboard

[Dwight-MEP]

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. 

[#2 · Accepted 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 🙂