# Use one cell`s value onto aother Cell to calculate percentage in SSRS 2008

### Question

•  Pls help me with my below issue. Hi, I developed SSRS 2008 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 Reference that Row Values / Matrix subtotal Values Like that ? Below is formate of my Matrix SSRS 2008 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 2008 Matrix ? I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean. Please help me!! Let me know if need information. Thanks. Shalin

Wednesday, September 22, 2010 3:54 PM

### Answers

• Hi Shalin,

We could calculate other cell’s subtotal using the SUM function within a specific scope, and then we will get the Percentage of different month. Therefore, you should add an adjacent row above the Bangalore row firstly, then type in the expression =SUM(Fields!Yourdatafield.Value)/SUM(Fields! Yourdatafield,"TablixName")

If I misunderstand you, could you please give more clarification, thanks.

Regards,

Challen Fu

Wednesday, September 29, 2010 6:52 AM