Aggregates sums in dimension level

  • Hello,

    I have a situation like this. In the foodmart 2000 sample database, we have the sales cube and there is a dimension called "TIME".

    In the Quarter level of this time dimension, I need the sums in aggregated level. For example, Q1 has the sum of months 1,2 and 3. Q2 has the Q1 value+4+5+6 and Q3 has Q2+7+8+9 and Q4 has Q3+10+11+12.

    Please ask me if you need any further clarifications. Kindly let me know if you have any clue how to do it. I am sure it is possible with custom rollup formula but I don't have enough exposture to that area yet.

    Thanks in advance,

    Anbu

  • The simpler solution would be to add a column to the fact table as " YTD Sales"

  • The simpler solution would be to add a column to the fact table as " YTD Sales"

  • Create a calculated Member with

    the formula

    Sum( YTD(), [Measure].[unit sales])

  • Create a calculated Member with

    the formula

    Sum( YTD(), [Measure].[unit sales])

  • Thanks for your reply. But how can I use the same when I have the same situation like this for a customer dimension?

  • Anbu, I am not to sure what you want to do with the dimension. Please explain

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply