Set Analysis Question (Excluding Dimensions)

[#1]

Hi All!

I have a question on how to make excluding of dimensions easier. I have this expression:

=sum ({<Year={$(=year($(vMaxDate)))}>}Revenue)

This gets the revenue for only the Year of the MaxDate. Let's say the maxdate is = 3/24/2014 so..

=sum ({<Year={2014}>}Revenue)

Take the Revenue for 2014. Now, Since I want to see it as a whole and not affected by every dimensions available.

Let's say I chose a month dimension. I don't want it to be affected by the month dimension so I created a set analysis like this..

=sum ({<Year={2014}, Month=>}Revenue)

And then I don't want it to be affected by other dimensions. Do I keep including it to the set analysis or is there an easier way to do this?

Thanks,

Donna

[AbhijitBansode]

create variable :

vSetModifier = Month=,Quarter=   // add whatever dimensions to include separated by comma

Experssion would be:

sum({<Year={2014},$(vSetModifier)>}Revenue)

[#3]

Hi,

Please find like this,

Sum({$<Year={},Month=,Customer=,Region=>}Sales)

Regards,

Raja.

[#4]

Hi,

Sum({1-$<Year=,Month=,Customer=,Region=>}Sales)

REgards,

Raja.

[#5]

Can you send me an example qvw with those expression? I got an error producing this one.

[#6]

Hi! I think this set analysis takes the previous Sales. Correct me if I am wrong. Thank you though for you answer

[semperaugustus · Accepted solution]

sum({1<Year={2014}>} Revenue)

1 in set analysis exclude all dimension

[#8]

Got it!

[#9]

Just a clarification, '1' ignores selections, 'TOTAL' ignores DIMENSIONS

sum({<Year={2014}>} TOTAL Revenue)

[pgriffiths]

Thanks Patrick Tabin,

Just what I was looking for.

'TOTAL' ignores DIMENSIONS