2 Replies Latest reply: Oct 6, 2016 12:41 PM by Sunny Talwar

# Ignore all dimensions, except for one

Pls, help!

Let me have 20 dimensions (Sex, Year, Country ... etc 20 dimensions). I also have a measure of "Sales". All in a single table.

How do I calculate the amount of expression on the "Sales", ignoring all the dimensions, except for one of the dimensions. For example, the dimension of "Sex" should be considered.

Like that:

=sum({1<(ignore)Sex>} Sale)

 Sales Sex Year Country … 20 100 1 2016 USA 200 2 2016 China 300 1 2016 Russian 100 2 2015 USA 200 1 2015 China 300 1 2015 Russian

Result:

If user choose Sex = 1 then the sum must be equal to 900;

If user choose Sex = 2 and Year = 2016 then the amount should be equal to 300;

If user choose Sex = 1 and Year = 2016 and Country = USA then the amount must be equal to 900;

• ###### Re: Ignore all dimensions, except for one

May be this:

=Sum({1<Sex = p(Sex)>} Sale)

or

=Sum({1<Sex = \$::Sex>} Sale)

• ###### Re: Ignore all dimensions, except for one

Attaching the sample back with the updated KPI objects