question

Sandip avatar image
Sandip asked

Retrieve a particular value from a matrix in SSRS 2008

I have showing value of 5 categories month-wise (4 months) in matrix like as follow: CategoryA 1 2 3 4 CategoryB 4 5 8 0 CategoryC 2 4 6 7 CategoryD 9 5 4 5 CategoryE 5 4 8 5 Now i have added 1 column (Outside group) in right showing total row-wise. What i am going to ask is that i want to add a row (outside group) to show percentage (Category D / CategoryA * 100) month wise (against all 4 coloum and "total" Column) Please suggest .....
ssrs-2008
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mister Magoo avatar image
Mister Magoo answered
I am not sure I should put a negative answer on, but I have not found a way to do that other than by adding some column(s) to the query that only contain values for the categories you want to perform a subtotal/total on...then use the new column(s) in your report / matrix totals... CategoryA 1 2 3 4 1 2 3 4 CategoryB 4 5 8 0 0 0 0 0 CategoryC 2 4 6 7 0 0 0 0 CategoryD 9 5 4 5 9 5 4 5 CategoryE 5 4 8 5 0 0 0 0
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
Take a look on the Miscellaneous set of functions like `Previous`, `Lookup` etc. [See Aggregate Functions Reference (Report Builder 3.0 and SSRS)][1] for details. [1]: http://msdn.microsoft.com/en-us/library/dd255275(v=sql.105).aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.