Answered by:
Matrix Totals by Column Group

Question
-
Hi there,
Sorry guys, got the post wrong the first time. This is what I am trying to do here;
I am having this issue here with a Matrix Totals, I will try to explain it with an example below;
ColumGroup1.Value1 ColumGroup1.Value2 ColumGroup1.Value3
RowGroup1.value1 10 7 0.7
RowGroup1.value2 5 2 0.4
Totals 10 9 ColumGroup1.value2/ColumGroup1.value1 (9/10) 0.9
So Totals for ColumGroup1.value1 and ColumGroup1.value2 for RowGroup1 is a straight Sum. Now for the ColumGroup1.Value3 is a percentage of ColumGroup1.Value2 / ColumGroup1.Value1. How do I perform the percentage on the Total for RowGroup1?
Thanks very much for your help guys.
Mid
- Edited by midway11 Thursday, October 4, 2018 6:29 PM
Thursday, October 4, 2018 4:19 PM
Answers
-
Sorry the first post was wrong. I posted the stuff I'm actually trying to do. Thanks.
- Marked as answer by midway11 Thursday, October 4, 2018 9:11 PM
Thursday, October 4, 2018 6:31 PM
All replies
-
Are ColumnGroup1,COlumnGroup2 etc different levels of column grouping? Or are they values within same group?
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook PageThursday, October 4, 2018 4:33 PM -
Sorry the first post was wrong. I posted the stuff I'm actually trying to do. Thanks.
- Marked as answer by midway11 Thursday, October 4, 2018 9:11 PM
Thursday, October 4, 2018 6:31 PM -
Sorry the first post was wrong. I posted the stuff I'm actually trying to do. Thanks.
ok
as per this what you need to do is expression like below for data portion
for the detail row
=IIf(Fields!ColumnGroupColumn.Value = "Value3",IIF(Sum(IIf(Fields!ColumnGroupColumn.Value = "Value1",Fields!ValueColumn.Value,0),"datasetname")>0,Sum(IIf(Fields!ColumnGroupColumn.Value = "Value2",Fields!ValueColumn.Value,0),"datasetname")/IIF(Sum(IIf(Fields!ColumnGroupColumn.Value = "Value1",Fields!ValueColumn.Value,0),"datasetname")>0,Sum(IIf(Fields!ColumnGroupColumn.Value = "Value1",Fields!ValueColumn.Value,0),"datasetname"),1),0),Sum(Fields!ValueColumn.Value))
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook PageThursday, October 4, 2018 7:10 PM -
That did it. Thanks very much for your help!!!Thursday, October 4, 2018 9:11 PM