I have a gallery that I would like to sort by 2 dimensions, but I want to sort both groups of items and within the groups. The app is to help run a meeting where teams present updates on their assigned items, so I need the items grouped by the team so that they are presenting at the same time. However, the order the teams should go in to present their updates in should be determined by the oldest item on the list, and then the order the team themselves should go in when presenting their items is by priority.
After researching not seeing anything that would do what I want (might be out there but I can't figure out a good search phrase for what I'm trying to do), my next thought was to add a column that would assign the date of the oldest item within a group to all items in that group so that SortByColumns would automatically keep the teams together, but I can't figure out how to do that either.
Here's some example data unsorted:
| Item |
Priority |
Team |
Age |
| ITEM10005 |
1 |
Team C |
100 days |
| ITEM10021 |
2 |
Team A |
44 days |
| ITEM10002 |
3 |
Team C |
3 days |
| ITEM10035 |
4 |
Team E |
135 days |
| ITEM10013 |
2 |
Team E |
10 days |
| ITEM10014 |
1 |
Team M |
23 days |
This is how I'd like the data to be sorted in the gallery:
| Item |
Priority |
Team |
Age |
| ITEM10013 |
2 |
Team E |
10 days |
| ITEM10035 |
4 |
Team E |
135 days |
| ITEM10005 |
1 |
Team C |
100 days |
| ITEM10002 |
3 |
Team C |
3 days |
| ITEM10021 |
2 |
Team A |
44 days |
| ITEM10014 |
1 |
Team M |
23 days |
Team E has the oldest item on the list, so Team E presents first. Of the two items assigned to Team E, the first on the list is the higher priority one even though that's not the oldest. Team C has the next oldest item assigned to them, so they are second, even though they also have the newest item. Of the two items assigned to Team C, the higher priority one is first. Teams A and M have one each, so these are in order from oldest to newest.
Anyone have any idea how to do this?
