Pls help me with my below issue.
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.