Pivot tables - show items with no data but still filter

[KatP]

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!

 

[GlennUK]

But I want to filter by month and if an area is not entered that month then it will not appear. This would mean I would need to enter the areas with no scores every month.

How many areas are there? I'm thinking you add a year's worth of zeros at the top at the beginning of the year. (=number_of_areas x 12 ... number of rows to add)