Sort pivot table with multi level

[nimi-e]

I have a Pivot Table with many columns.
I want the Pivot the ability to sort one of the columns in a way that the whole column is sorted and not the relative position in the hierarchy.

example:

name	Product	Sum
Joe	A	400
Joe	B	200
Joe	B	300
Alice	A	500
Alice	A	200
Alice	C	300

<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>
</tbody>

If I use the regular sort on the Sum column, I will get the data sorted partially.

name	Product	Sum
Alice	A	500
Alice	A	300
Alice	C	200
Joe	A	400
Joe	B	300
Joe	B	200

<colgroup><col><col><col></colgroup><tbody>
</tbody>

​

As you can see, the Sum column is sorted only relevant to the Name column.
I want the whole column to be sorted.

Expected result:

name	Product	Sum
Alice	A	500
Joe	A	400
Alice	C	300
Joe	B	300
Alice	A	200
Joe	B	200

<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>
</tbody>

Thank you in advance,
NImi