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
mdx
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