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

# 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:

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:

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

• ###### Re: Pivot table sums should include values for surpressed dimensions

This?

Dimension

Country

Expression

=If(Dimensionality() = 1 and SecondaryDimensionality() = 0, Sum(Aggr(Sum(Value), Business)),

If(Dimensionality() = 0 and SecondaryDimensionality() = 1, Sum(Aggr(Sum(Value), Country)),

If(Dimensionality() = 0 and SecondaryDimensionality() = 0, \$(vTotal), Sum(Value))))

Here \$(vTotal) is a variable with the following definition

=Sum(Value)