|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
Subtotals in matrixes |
|
prl
|
Subtotals in matrixes
Posted:
Wednesday, April 01, 2009 12:32 PM (GST)
|
|
Hello,
I'm trying do something I thought would be simple: I have a matrix that gives me sales of certain brands by month with automatically generated total row and column. Something like this:
-----------------------------------------
| Jan || Fev || Total |
--------------------------------------------------
| Honda | 20 | 20% || 10 | 20% || 30 | 20% |
| Ford | 40 | 40% || 10 | 20% || 50 | 33% |
| Nissan | 40 | 40% || 30 | 60% || 70 | 47% |
--------------------------------------------------
| Total | 100 | 100% || 50 | 100% || 150 | 100% |
--------------------------------------------------
I have this in my report:
------------------------------------------------------------
| =Fields!Month.Value | Subtotal |
| | (automatically generated) |
------------------------------------------------------------------------------------
| =Fields!Brands.Value | =Sum(Fields!Sales.Value) | % |
--------------------------------------------------------
| subtotal |
| (automatically |
| generated) |
-------------------------
The problem is that I don't know how to do that percentage, since I can't access the total for the column I need. For instance, there were 40 sales for Nissan cars in January. That's 40 / 100 (the total of sold cars in that month). Is there any way I can do this automatically?
Thanks in advance!
|
|
|
|
|
|
|
|
|