Hello all:
I've created a Pivot Table to summarize statistics by employee and date(Monthly grouping for daily data) however I've found that when employee names or dates are removed from the pivot table source data they are not removed from the pivot table drill down menu. Does anyone know a way around this? (Refreshing the data does not work.)
Thanks,
Max
I've created a Pivot Table to summarize statistics by employee and date(Monthly grouping for daily data) however I've found that when employee names or dates are removed from the pivot table source data they are not removed from the pivot table drill down menu. Does anyone know a way around this? (Refreshing the data does not work.)
Thanks,
Max