I have several pivot charts on Sheet "Pivot2", from which i am fetching data to Sheet "Dashboard2". On Sheet "Dashboard2" at address D4 i have inserted the following formula but it is not showing data, what is the issue?
formula: =IFERROR(GETPIVOTDATA("Break down Degree",Pivots2!$T$1,"Break down Degree",B4),"")
Attached are snapshots: formula.PNG formula 2.PNG
Bookmarks