Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All,
in my model i have a pivot table with an expression based on another expression (column()).
the rows are presented OK but the total is taking all the rows into the value. i.e. :
dim1 | expression a | expression b |
total | 47.4 | 47.4 |
abc | 16 | 0 |
abd | 28 | 28 |
abe | 3.4 | 0 |
the total of expression b should be 28.
any ideas ?
advanced thanks
this option is greyed out
Hi @ilanbaruch
Try like below
If(Rowno() = 0 or isnull(Rowno()), Sum(Aggr(urexpression, dim1)), urexpression)
Hope it helps