Sorting issue in bar chart

[#1]

hi Everyone,

i have two bar chart as below.

In first table, i want to show only 4 customers when their gross margin % is greater than 30% and sort them by customers with sum (revenue) in descending order.

Please find refer the attached qvf

thanks in advance

[Gysbert_Wassenaar]

See attached qvf. Is that what you want?

[#3]

No, i want sorting based on customers with their revenue when gross Margin % is greater than 30%

In first table, i want to show only 4 customers when their gross margin % is greater than 30% and sort them by customers with sum (revenue) in descending order.

-> 4 customers with gross Margin % greater than 30%

-> they should be sort based on their sum(revenue) in descending order

[#4]

Oh, i got a solution !

I have used the expression to customers by revenue.

thanks

[Chanty4u]

Great.

Please close the thread by making correct and helpful answers.

[#6]

sorry, though i was able to sort them by revenue with greater than 30% gross margin.

but still i am not able to define to show only 4 customers on bar chart.

Because the limit condition i have used to get customers more than 30%.

then how can i get only 4 customers