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

    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?