8 Replies Latest reply: Jun 11, 2016 8:42 AM by Stefan Wühl RSS

    Show all values but hide outside selection

    Nick Listerman

      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?

       

      A.
      Screen Shot 2016-06-07 at 10.50.46 AM.png

       

      B.
      Screen Shot 2016-06-07 at 10.51.00 AM.png

      C.
      Screen Shot 2016-06-07 at 11.08.32 AM.png