How i can combine two condition for the top 4
How i can have this
Are you looking for change of sort order?
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
What object are you using? Would it be possible to provide a sample to work with?
Here is an exemple
You can use in Sort Tab
May be this as your sort expression:
why you use (*1000000)
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.
Thanks its work
Retrieving data ...