# 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 Thursday, October 4, 2018 6:29 PM
Thursday, October 4, 2018 4:19 PM

• Sorry the first post was wrong. I posted the stuff I'm actually trying to do. Thanks.
• Marked as answer by 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?

Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog

Thursday, 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 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))