Sort table rows by metric while preserving row hierarchy

Hi all,

In a "Table" visualization, I'd like to be able to sort multiple attributes by a metric in a way that preserves their groupings. I've been trying every possible sort I can think of, but I can't figure out how to do this.

For example, imagine I have 2 attributes: Attribute 1 {A,B} and Attribute 2 {X,Y}. I'd like to be able to sort them so the table looks like this:

| Attribute 1 | Attribute 2 | Metric |
|-------------|-------------|--------|
| B           | Y           | 32     |
|             |-------------|--------|
|             | X           | 12     |
|-------------|-------------|--------|
| A           | X           | 17     |
|             |-------------|--------|
|             | Y           | 3      |
|-------------|-------------|--------|

Some things of note here:

1. B is sorted above A because 32+12 is greater than 17+3.
2. B.Y is sorted above B.X because 32 is greater than 12, and A.X is sorted above A.Y because 17 is greater than 3.
3. A.X is not sorted above B.X even though 17 is greater than 12, because B is already sorted above A (per point 1).

This is trivial with a pivot table in Excel (and you can even sort each row with entirely separate value criteria), but here in Zendesk, if you sort by value descending, you would always split up A and B in that example (because A.X gets sorted above B.X).

Is there a way to do this simple hierarchy-preserving sort with Zendesk tables, or do I have to export and manipulate outside of Zendesk to get this result?