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

[dickelsa]

Hi,

Can you please tell me if there is any logic behind the sorting?

Regards,

Dick

[prma7799]

Yes. I put ytd sales expression as descending mode in sorting tab

[dickelsa]

You should check then if the sorting orders on all other dimensions are switched of, can you please attach your dashboard for more insight?

[prma7799]

All other dimension are switched off in sort tab. It is not possible to attache doc

[dickelsa]

Maybe you need to use the expression in the sorting, instead of sorting on expression?

[#7]

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

[dickelsa]

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..

[antoniotiman]

Hi,

If Dim is Your Dimension, in Tab Sort Try expression

If(Dim <> 'REST,Rank(Sum(Value)),9999999)

Regards,

Antonio

[dickelsa]

If(Dim <> 'REST',Rank(Sum(Value)),9999999)

you forgot a quote mark