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

Answer 1

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 Page

Answer 2

Sorry the first post was wrong. I posted the stuff I'm actually trying to do. Thanks.

Answer 3

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 Page

Answer 4

That did it. Thanks very much for your help!!!