Post reply

SSRS Matrix Report 2005 - Percentage of Total for One of Cell issue

  • May 12, 2010 at 7:13 am

    #140266

    Pls help me with my below issue.

    Hi,

    I developed SSRS 2005 Matrix Report.

    In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

    How can i Referencethat Row Values / Matrix suntotal Values Like that ?

    Below is formate of my Matrix SSRS 2005 Report.

    Jan Feb March

    Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

    Bangalore 135 192 197

    Delhi 149 185 278

    Total 284 377 485

    How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2005 Matrix ?

    Let me know if need information.

    Thanks.

  • May 12, 2010 at 7:20 am

    #1166180

    Please post this in the BI forum - this is not SSIS related, as far as I can see.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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