What I'd like to do is add a Percentage column to the right of the right-based Totals column. So the columns would read Col1, Col2, .., ColN, Total, Percentage.
Is this possible?
Thanks.
You could do something like - matrixcoltotal / matrixtotal and set your Format Code to P0 on the properties window.
Your expression will look something like this. =Sum(Fields!ReportField.Value,"MatrixGroup")/Sum(Fields!ReportField.Value,"dataset"). Dont forget to change the FormatCode.
|||How would I place this column to the RIGHT of the Subtotal column?|||
Add an invisible column group which will be grouped by the percentage expression and add the subtotal to this colum group have the which will give you the sum of all individual percentages.
Shyam
|||Here is the error message I am receiving:"A group expression for the matrix 'matrix1' includes an aggregate function. Aggregate functions cannot be used in group expressions."
I created a new Column group, outside of my month-by-month column group, and made it invisible. I do see a new "Total" to the right....however when I put in my sum(value, "InnerRowGroup")/sum(value, "OuterRowGroup") as the group expression, I get the above error.
Thank you both greatly for your help. I feel about 75% towards getting this to work.
Jason
|||
No, you dont have to group by the aggregate which is an obvious logical error. Just group by the expression without the sum function which would be:
Fields!InnerGroupField/Fields!OuterGroupField
Then using the subtoal would automatically mean a sum which is what you want I guess.
Shyam
|||What if the percentage I want to calculate is the ratio between two columns? Is this possible, or will I have to pivot the data in the database before I send it to SSRS? This would suck since I have to completely revamp the stored proc.