Post reply

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

  • May 12, 2010 at 7:12 am

    #386911

    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

    #1166185

    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

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

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