sorting

[prma7799]

Hi All,

I have one pivot table and i am taking 5 calculated dimension for top 5 product or we can say top 5 record and other record come as REST.

Now my data is coming properly but i need sorting in proper way.

For example

REST	FY16	2,900
P LOGISTICS	FY16	665
D INDIA	FY16	454
A.K.SERVICES	FY16	404
N.S.ARMA	FY16	387
MI LOGISTICS	FY16	384

but I required below output... I want REST record below to top 5 record.

P LOGISTICS	FY16	665
D INDIA	FY16	454
A.K.SERVICES	FY16	404
N.S.ARMA	FY16	387
MI LOGISTICS	FY16	384

REST

FY16

2,900

[antoniotiman]

Yes,I'm sorry.

[prma7799]

Hi Antonio,

I tried your solution Rest values is go down but sorting is not coming properly.

PFA.

Thanks

[prma7799]

Hi sunindia‌,

Can you please help me out.

Thanks

[Digvijay_Singh]

For me the suggested expression is working, please check. Hope u hv switched off Product sorting check boxes.

[prma7799]

Hi Digvijay,

I checked that one but sorting is not coming properly.

Thanks