Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try this
sum(aggr(sum(expression1)/sum(expression2),Dimenssion))
Thanks
Try using a straight table instead of pivot table.
i tried but striaght table is also not reflecting with output that i want.......
Hi
Try this
sum(aggr(sum(expression1)/sum(expression2),Dimenssion))
Thanks