1 Reply Latest reply: Sep 9, 2016 5:17 PM by Sunny Talwar RSS

    Pivot table sums should include values for surpressed dimensions

      I am struggling with the following:

      I need to sum the values in a Pivot table, including  the cases where the Dimension = empty, even when these are surpressed.


      For example:

      Test QV Not surpressed.png

      In the above example the Empty values in dimensions are not surpressed. The totals include values for these empty


      When the empty value dimensions are hidden it looks like this:

      Test QV surpressed.png

      How can I show the totals including values from Surpressed dimensions ( So avoid that the totals change when I surpress empty values in dimension)