Previous(Expression, AggFunction, PreviousScope, AggScope) ??

Hi all,

We are trying to produce a report using a matrix that would show percentages to the column groups in the cells (ratio to parent along the columns):










Colgroup = 1

Colgroup = 2

€¦






Col1

Col2

Col3

Col4

€¦


Rowgroup= 1


Row1

3 / (3+9)

9 / (3+9)

1 / (1+6)

6 / (1+6)

€¦


Row2

€¦

€¦








Rowgroup = 2


Row3

€¦

€¦








Row4

€¦

€¦








€¦













So in the cell we want Field.Value / Sum(Field.Value,"Colgroup1","Row1").

If we add the subtotals column at colgroup level, the value showing up there is the denominator we need.

The problem is you can only have one scope in the aggregation functions so just Sum(Field.Value,"Colgroup") would sum along the rows and Sum(Field.Value,"Row") would sum alnog all the columns, not just those in Colgroup=1.
We came accross to possible undocumented features. The Previous function and a intellisense hint for a third way of writing Sum showing three arguments which we dont't know how to use. Would any of these be a solution?

We didn't find more help on these functions anywhere however...

Thanks for your help