Post reply

SSRS Matrix 2005 - PErcentage of Total for One of Cell Value Issue

  • May 12, 2010 at 7:14 am

    #222379

    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:27 am

    #1166186

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic920437-150-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 24, 2011 at 3:36 am

    #1372434

    Write this code in EDIT EXPRESSION of the percentage textbox.

    =iif( inscope("matrix1_Prd_grp"),

    IIF(ISNOTHING(Fields!ACH_VAL.Value), 0, IIF(Fields!TGT_VAL.Value=0, 0, (Fields!ACH_VAL.Value/Fields!TGT_VAL.Value)*100 )),

    IIF(ISNOTHING(sum(Fields!ACH_VAL.Value)), 0, IIF(sum(Fields!TGT_VAL.Value)=0, 0, (sum(Fields!ACH_VAL.Value)/sum(Fields!TGT_VAL.Value))*100 ))

    )

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

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