Excel Dashboard Refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-2137175%22%20slang%3D%22en-US%22%3EExcel%20Dashboard%20Refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137175%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20building%20a%20dashboard%20using%202%20major%20data%20sets%20and%20pivot%20tables%20from%20each.%26nbsp%3B%20On%20the%20dashboard%2C%20I've%20included%20cells%20with%20calculations%20involving%20data%20from%20my%20pivot%20tables.%26nbsp%3B%20Up%20until%20now%2C%20my%20slicers%20have%20always%20automatically%20updated%20my%20dashboard%20calculations%20accordingly%20with%20the%20changing%20pivot%20table%20data.%3C%2FP%3E%3CP%3EI%20just%20went%20in%20to%20add%20a%20new%20calculation%20in%20a%20cell%20and%20now%20all%20of%20my%20previous%20calculations%20fail%20to%20update%20when%20I%20change%20the%20timeline%2Fslicer.%3C%2FP%3E%3CP%3EI%20have%20no%20idea%20what%20I%20did!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2137175%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2137211%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dashboard%20Refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137211%22%20slang%3D%22en-US%22%3EWhat%20is%20the%20formula%20that%20you%20added%3F%3C%2FLINGO-BODY%3E
New Contributor

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!

2 Replies
What is the formula that you added?

@Jihad Al-Jarady 

=(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")