Currently I have worksheet 1 and worksheet 2, pivottable, rawdata. Worksheets 1 and 2 both want to pull info from the pivot table, specifically a value associated with a date, when slicer filters are applied the correct data is retrieved but when unfiltered or the incorrect filter applies the data is incorrect.
Is there a way to ensure that the slicer filter is applied when a worksheet is selected? So, if I select worksheet A, filter 1 applies and I get the correct data without having to manually change the filter every time?
Is there a way to ensure that the slicer filter is applied when a worksheet is selected? So, if I select worksheet A, filter 1 applies and I get the correct data without having to manually change the filter every time?