Pivot table dimension expression columns totals

[sunilkumarqv]

Hi all ,

can bring partial sum for dimension expression for pivot table i have total four dimensions with in that two expression and one expression i have tried to do with could any one help out of this please.

[arulsettu]

HI

have you tried this

[sunilkumarqv]

it wont work in my case the dimension which have used with aggr functions is there anything which we can do in that expression . 

[arulsettu]

can you post your expression

[sunilkumarqv]

My expression

aggr(sum({<feil={'1'},Month=>}),Dimension1,Dimension2)

[arulsettu]

here we need a advance aggregation

try like this

=sum(aggr(sum({<feil={'1'},Month=>}),Dimension1,Dimension2))