Forum Discussion

CC852's avatar
CC852
Frequent Visitor
2 years ago
Solved

How to sort Grouped items

I have managed to combine some prices but now they are not in the order I would like:   I would like them to display as $1-$3 then $5-$10 then $20+   How can I sort the grouped items manual...
Need Help
Tips and Tricks
Tutorial Requests
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    You can add a new table to do it or add a new column in your current and categorise your price ranges.
    If you share your file I can help you with this

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Create a ID for each range of price that you defined, and after order your column by the ID that you created.
For example:
ID | RangeName
1  | $1-$3
2  | $5-$10
3 | $20+

After use  "Sort by Column" and choose "ID"

 

CC852's avatar
CC852
Frequent Visitor
2 years ago

Do I need to create a new table for the prices and the desired groups first?

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    You can add a new table to do it or add a new column in your current and categorise your price ranges.
    If you share your file I can help you with this

    • CC852's avatar
      CC852
      Frequent Visitor
      2 years ago

      Thanks, I got more understanding with the break down of steps and then found a video that was similar to your descriptions! https://www.youtube.com/watch?v=4xapOrfLvbg