Sort Legend in Pie Chart (Sort everything ascending by value except one entry)

[#1]

Dear all,

I'm looking for a solution in sorting the entries in a pie chart.

I want to sort all entries by the amount of Revenue.

Product S 1.000,-

Product A 899,-

Product K  780,-

Product X  400,-

I want the Product A to be the last:

Product S 1.000,-

Product K  780,-

Product X  400,-

Product A 899,-

Thanks for your help guys,

Daniel Philips

[#2 · Accepted solution]

Hi Daniel

Just sort the pie with expression

=sum(  if( Product ='Product A' ,  0,  revenue) )

JJ

[#3]

Thanks JJ. 🙂

Talk to myself: first think, then post