sorting issue

[upaliwije]

Hi friends

I have below pivot table in my Qv Doc.

Here my dimension is a calculated with following  syntax,

=If(Aggr(Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos)), [MAKE])<=8, [MAKE], 'Others')

I want to sort this in such a way  Rows representing others should come immediately above total rows . Kindly help me with sorting expression

[upaliwije]

Hi Friends,

Can Someone help me pls.

[StarinieriG]

Hi,

try with this expr

If(Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos))<=8, Rank(Sum({<VEHICLE_TYPE={'CAR/JEEP'}>}POLNos)), 9)

[upaliwije]

Thanks

But It does not work please

[Brett_Bleess]

Likely going to need to attach a QVW file on this one, so folks can see underlying data model as well...

Regards,
Brett