I have a pivot table showing two dimensions: Organizations in rows, MonthYear in columns, w/ count of meetings as the expression.
When I select the MonthYear(s) I want to view, the table looks perfect (see below img A). The months with no values remain because other organizations have values in that column. When I select a single organization (img B) the null/missing months disappear. What do I need to do for these to stay? Create a query that populates the missing data?
The one thing I have tried is to enable "Show all values" on the MonthYear but then I get every MonthYear from my Master Calendar (img C). Can I somehow hide the MonthYear(s) that are not selected by the user?