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 |
Hi,
Can you please tell me if there is any logic behind the sorting?
Regards,
Dick
Yes. I put ytd sales expression as descending mode in sorting tab
You should check then if the sorting orders on all other dimensions are switched of, can you please attach your dashboard for more insight?
All other dimension are switched off in sort tab. It is not possible to attache doc
Maybe you need to use the expression in the sorting, instead of sorting on expression?
Hi,
Go to Sort tab,
Use Sort by expression option
If(Column_name ='P LOGISTICS',1,
If(Column_name ='D INDIA',2,
If(Column_name ='A.K.SERVICES',3,
If(Column_name ='N.S.ARMA',4,
If(Column_name ='MI LOGISTICS',5,
If(Column_name ='REST',6))))))
i think this should work.
Regards,
KC
Yes but this solution works only for 1 situation, but if N.S.ARMA has a lesser lesser value then A.K.SERVICES, it does not switch places... again, if you attach an exemple of your dashboard, it would be more clear..
Hi,
If Dim is Your Dimension, in Tab Sort Try expression
If(Dim <> 'REST,Rank(Sum(Value)),9999999)
Regards,
Antonio
If(Dim <> 'REST',Rank(Sum(Value)),9999999)
you forgot a quote mark