Feb 15 2021 11:50 AM
I've been building a dashboard using 2 major data sets and pivot tables from each. On the dashboard, I've included cells with calculations involving data from my pivot tables. Up until now, my slicers have always automatically updated my dashboard calculations accordingly with the changing pivot table data.
I just went in to add a new calculation in a cell and now all of my previous calculations fail to update when I change the timeline/slicer.
I have no idea what I did!
Feb 15 2021 12:01 PM
=(GETPIVOTDATA("Total",'Hours Analysis'!$I$1,"Category","Hours","Element Group","Confirmed")-GETPIVOTDATA("Total",'Hours Analysis'!$I$1,"Category","Hours","Element Group","Scheduled"))/GETPIVOTDATA("Total",'Hours Analysis'!$I$1,"Category","Hours","Element Group","Scheduled")