MDX: Aggregates over a set

Posted by =!3fb7.13e2.c801.b5f3 on Stack Overflow See other posts from Stack Overflow or by =!3fb7.13e2.c801.b5f3
Published on 2010-03-17T14:22:16Z Indexed on 2010/03/18 2:31 UTC
Read the original article Hit count: 380

Filed under:

Hi!

What I am trying to achieves looks very simple, yet I cannot make it work. My facts are orders which have a date and I have a typical time dimension with the 'Month" and 'Year' levels.

I would like to get an output which lists the number of orders for the last 6 months and the total, like this:

Oct 2009   20
Nov 2009   30
Dec 2009   25
Jan 2009   15
Feb 2010   45
Mar 2010    5
Total     140  

I can create the set with the members Oct 2009 until Mar 2010 and I manage to get this part of my desired output:

Oct 2009   20
Nov 2009   30
Dec 2009   25
Jan 2009   15
Feb 2010   45
Mar 2010    5

Just I fail to get the total line.

© Stack Overflow or respective owner

Related posts about mdx