sort the table based on other field

[arulsettu]

Hi

     i am trying to achieve in straight table some thing like this

     dimension is drill down

     make

     model

     use

expression is finding ratio

sum(commission)/sum(amount)

now what i need is take the top ten ratio based on  vehicle count. that means highest vehicle count of ratio values should come.

for this should i need to use rank function?

can any one suggest some idea

thank you

[settu_periasamy]

Hi,

This will also give the same result..

Dimension Limit -> First 11

[arulsettu]

Thanks setu Count column i am not going to show its for reference

[PradeepReddy]

you can hide the 'Count' expression in presentation tab... then the result would be what you are expecting..

[settu_periasamy]

Hi Arul,

Actually, it is not based on your Count Expression, It is based on the Largest 11 value..

if you remove the 'Count' Expression, it won't affect here...

Check that..

[arulsettu]

No its not working. it bring only largest 10 loss ratio

[settu_periasamy]

Hi Arul,

It is working for me.

I think, you tried with formula and Dimension Limit..

Check the Attachment..