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:
[TABLE="width: 216"]
<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>[TR]
[TD="width: 72, align: center"]name[/TD]
[TD="width: 72, align: center"]Product[/TD]
[TD="width: 72, align: center"]Sum[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]200[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]300[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]500[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]200[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]300[/TD]
[/TR]
</tbody>[/TABLE]

If I use the regular sort on the Sum column, I will get the data sorted partially.
[TABLE="width: 194"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]name[/TD]
[TD="align: center"]Product[/TD]
[TD="align: center"]Sum[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]500[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]300[/TD]
[/TR]
[TR]
[TD="align: center"]Alice[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]200[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]300[/TD]
[/TR]
[TR]
[TD="align: center"]Joe[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]200[/TD]
[/TR]
</tbody>[/TABLE]

​

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:

[TABLE="width: 216"]
<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 72"]name[/TD]
[TD="class: xl65, width: 72"]Product[/TD]
[TD="class: xl65, width: 72"]Sum[/TD]
[/TR]
[TR]
[TD="class: xl65"]Alice[/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]500[/TD]
[/TR]
[TR]
[TD="class: xl65"]Joe[/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]400[/TD]
[/TR]
[TR]
[TD="class: xl65"]Alice[/TD]
[TD="class: xl65"]C[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl65"]Joe[/TD]
[TD="class: xl65"]B[/TD]
[TD="class: xl65"]300[/TD]
[/TR]
[TR]
[TD="class: xl65"]Alice[/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
[TR]
[TD="class: xl65"]Joe[/TD]
[TD="class: xl65"]B[/TD]
[TD="class: xl65"]200[/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance,
NImi