Post reply

matrix - Calculate %

  • August 21, 2008 at 1:48 pm

    #196617

    Hi all

    I have wasted a lot of time trying to reach this result:

    When I have just one group in rows...it's easy...I only have to make something like:

    =SUM(Fields!Value.Value)/SUM(Fields!Value.Value,"Month_Group")

    But my problem is how can I identify the subtotal 15 for Customer A and subtotal 3 for customer B (with nested aggregate...since it is contained in groups: "Month_Group" and "Prod_Group"), since if I do:

    -SUM(Fields!Value.Value,"Customer_Group") it sums all the rows;

    -SUM(Fields!Value.Value,"Month_Group") it sums all the columns...result is 15+3=18...but I want to identify the number 15 for the first Customer_Group=Customer A and identify the number 3 for Customer_Group=Customer B.

    I know this (neste aggregations) is a limitation in SSRS 2005, but I've seen some workarounds using Code...but it doesn't fit my problem...

    Any suggestions?

    Thanks in advance.

  • January 4, 2010 at 8:56 am

    #1098484

    I have the same question, did you ever receive a solution?

  • January 4, 2010 at 11:19 am

    #1098542

    jfrance (1/4/2010)

    I have the same question, did you ever receive a solution?

    This post has more than 1 year...glad to see someone replying...lol

    Yes, you just "play" with INSCOPE function. Take a look and then let me know.

Viewing 3 posts - 1 through 2 (of 2 total)

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