pivot expression total

[ilanbaruch]

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

[Kushal_Chawda]

@ilanbaruch  For that expression, change the Total Model  as " Sum" Of rows.

[ilanbaruch]

this option is greyed out 

[MayilVahanan]

Hi @ilanbaruch 

Try like below

If(Rowno() = 0 or isnull(Rowno()), Sum(Aggr(urexpression, dim1)), urexpression)

Hope it helps