How to sort Report Legends as per choice Order ?

[Teju Dhoran]

Hi team,

I have report of type Column, Report is grouped by Stage field (choice type), The report shows legends in Alphabetical order. We want legends to be shown as per the Stage order.

Report Ranges is not working on choice field.

Here legends are sorted in alphabetical order, but I want it in below order

Open,  Planning, Doing, Close

Can some one help?

[Faizeal Mohamed]

Hi,

The legend should display how we configured the order in the choice values. Could you please check the choice list order in the field?

Thanks,

Faizeal.

[Teju Dhoran]

Yes, the sequence is correct. It is not showing legends as per sequence.

Open (10),  Planning (20), Doing (30), Close(40) this is the order in choice table.

[Faizeal Mohamed]

Add sort in the filter for stage (a to z) and try.

[Teju Dhoran]

Already tried that, it is not working. It only reverse the order.