locked
Matrix Totals by Column Group RRS feed

  • 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 Page

    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 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 Page

    Thursday, October 4, 2018 7:10 PM
  • That did it. Thanks very much for your help!!!
    Thursday, October 4, 2018 9:11 PM