Hello,
I have a pivot table that has division, area and score and a slicer to filter by month.
I want to filter by division and month but see all the areas within that division regardless of whether they have a score or not.
If i use the ‘show items with no data’ setting for the area. It shows me all the areas but I only want to see the areas under a particular division.
Any help is greatly appreciated!
I have a pivot table that has division, area and score and a slicer to filter by month.
I want to filter by division and month but see all the areas within that division regardless of whether they have a score or not.
If i use the ‘show items with no data’ setting for the area. It shows me all the areas but I only want to see the areas under a particular division.
Any help is greatly appreciated!