9 Replies Latest reply: Jun 29, 2016 9:35 AM by Said Farid

Top 10

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

• Re: Top 10

Are you looking for change of sort order?

• Re: Top 10

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

• Re: Top 10

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

• Re: Top 10

Here is an exemple

• Re: Top 10

You can use in Sort Tab

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

Regards,

Antonio

• Re: Top 10

May be this as your sort expression:

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

• Re: Top 10

why you use  (*1000000)

• Re: Top 10

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.

• Re: Top 10

Thanks its work