Sort data in a report using hidded value

[Gadwood74]

I have a table telling me :

1. the name of an account group

2. The order it should show up in a report

See the attached picture. The group "Ventes Externes" should show up first. The thing is that I don't want the order number to show up, only the name of the group.

So can we specify sorting of a feild based on somehing else than alphabetical order?

[vanessafvg · Accepted solution]

Yes in the modelling columns of the visual pane, click on your field in the table  and then select the sort by and choose the correct field.

the only thing is they will need to have the same granularity as far as i remember.