Forum Discussion
Ordering a ledgend based on age range
I need to order these : 0-5 = 1 6-20 = 2 21-50 = 3 50> = 4 I have a calculated column called 'Age Profile' which outputs 0-5 etc.... I would be really grateful if someone coul...
Not sure if this is the best way to go about it, but I would:
1. Create a conditional column in query editor that generates a new column that states the order you want
2. Highlight the Age Profile column in the Fields tab , click on modeling tab, click on sort by column, then select the order column you created in step 1.
Please let me know if you need more information.
