Hi
I have made a pivot table on sales figures based on weeks, seasons (we sell several seasons at the same time), department and net sales. I filtered the data in slicers to quickly be able to alternate between seasons, departments and weeks.
My problem is that when I pick "Total" (all seasons) for a specific week, and double click on the cell to find the source data (thank you Chandoo!) I find that the table has included a lot more than just "Total".
Slicer settings are week "2014w29" and "Total"
I have attached an example of what the source file looks like.
I have made a pivot table on sales figures based on weeks, seasons (we sell several seasons at the same time), department and net sales. I filtered the data in slicers to quickly be able to alternate between seasons, departments and weeks.
My problem is that when I pick "Total" (all seasons) for a specific week, and double click on the cell to find the source data (thank you Chandoo!) I find that the table has included a lot more than just "Total".
Slicer settings are week "2014w29" and "Total"
I have attached an example of what the source file looks like.
Last edited: