1 Reply Latest reply: Jan 24, 2018 3:55 PM by Bill Markham RSS

    How can I isolate a Dimension so it does not get limited

    Scott Robertson

      Hope this is just some simple step or syntax I am missing here, but I am working with a 2 dimensional pivot.

       

      The first dimension is row-level and denotes a type of widget, the second dimension is in columns across the top denoting a month.  The pivot simply shows count of widgets completed each month.

       

      The problem is however, that when a user selects a month using the 2nd dimension, the data is limited to ONLY widgets completed within that month, where I need it to show the nulls.  Basically need the equivalent of adding {1} to a measure to ignore selections (ideally i only want it to ignore the date dimension, not other dimensions available to filter by).

       

      Any help would be greatly appreciated.

       

      Thanks!