SORTING ORDER

[upaliwije]

Hi friends

I have following expression in sort tab of my Pivot Table. But it does not work well. Total row comes in between records which in fact should be the last row.

Kindly let me the error I have done in expression

[ogautier62]

Hi,

you want to be ordered by ratio on RM,

with total last row, ok ?

Total seem to be an item in RM,

if so try as sort expression on RM :

if(RM <> 'TOTAL', your ratio expression, 100)

regards