8 Replies Latest reply: May 2, 2014 8:47 AM by Patrick Tabin

# Set Analysis Question (Excluding Dimensions)

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

• ###### Re: Set Analysis Question (Excluding Dimensions)

create variable :

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

```sum({<Year={2014},\$(vSetModifier)>}Revenue)
```
• ###### Re: Set Analysis Question (Excluding Dimensions)

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

• ###### Re: Set Analysis Question (Excluding Dimensions)

Hi,

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

Regards,

Raja.

• ###### Re: Set Analysis Question (Excluding Dimensions)

Hi,

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

REgards,

Raja.

• ###### Re: Set Analysis Question (Excluding Dimensions)

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

• ###### Re: Set Analysis Question (Excluding Dimensions)

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

1 in set analysis exclude all dimension

• ###### Re: Set Analysis Question (Excluding Dimensions)

Got it!

• ###### Re: Set Analysis Question (Excluding Dimensions)

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

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