Top 10

[emteam162]

Hi,

How i can combine two condition for the top 4

Dim1	Top4	Exp2
a	15%	152
b	12%	125
c	11%	90
d	11%	120

How i can have this

Dim1	Top4	Exp2
a	15%	152
b	12%	125
d	11%	120
c	11%	90

Many thanks

Said

[sunny_talwar]

Are you looking for change of sort order?

[emteam162]

yes, if i have Value of each item are equal then in my exemple i have item d and c are equal then i see second condition

(exp2) i take item how have more

[sunny_talwar]

What object are you using? Would it be possible to provide a sample to work with?

[emteam162]

Here is an exemple

[antoniotiman]

You can use in Sort Tab

Sum(GP%)*10000+Sum(GP)

Regards,

Antonio

[sunny_talwar]

May be this as your sort expression:

Sum(Sales-COS)/Sum(Sales)*1000000-Sum(GP)

[emteam162]

why you use  (*1000000)

[sunny_talwar · Accepted solution]

To give GP% more weight in the sorting compared to the GP. I would have gone with 100, but since GP% is decimal number, I went with an even higher number. Depending on size of the GP and GP%, I would adjust up or down 10000.

[emteam162]

Thanks its work