Set Expression

[#1]

Hi Community,

I have one problem with set expression.

In my pivot table i have three expression with one dimension.

3rd expression is sum(expression1)/sum(expression2)

its gives me currect output at row lavel but at bottum i want total of expression3 but

it was not appear.

Thanks

[nagaiank]

Try using a straight table instead of pivot table.

[#3]

i tried but striaght table is also not reflecting with output that i want.......

[VishalWaghole · Accepted solution]

Hi

Try this

sum(aggr(sum(expression1)/sum(expression2),Dimenssion))

Thanks