Forum Discussion
Sort table Age Range
I have a table with a 'Category' column with several categories, one of the catogories is Age range.
The other column is 'group' which is split into:
Less than 25
26-30
31-40
41-54
55+
I have created a table visual in report view to filter this only to the Age rage show the values of the group.
however, the table sorts the columns as
26-30, 31-40, 41-54, 55+, Less than 25.
I want the table to be sorted so it shows Less than 25,26-30,31-40,41-54,55+
1 Reply
Hi RG92
I understand that you want to display rangers in a certain order.
- I suggest that you create a new static table with those ranges
- Add a column 'Order' with numbers (order of values)
- Load the table and link it to the fact one
- In your new table select ranges column and click Column Tools / Sorting by Order column
- Use this one in your visual and you get the desired result
Did it work ? 👍 A kudoswould be appreciated 📢 Mark it as a solution to help spreading knowledge
