Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Yes,I'm sorry.
Hi Antonio,
I tried your solution Rest values is go down but sorting is not coming properly.
PFA.
Thanks
For me the suggested expression is working, please check. Hope u hv switched off Product sorting check boxes.
Hi Digvijay,
I checked that one but sorting is not coming properly.
Thanks