Hi everybody

I have a pivot table with 2 datas (HI and LOW) for each row
I want to sort them descending on BOTH columns -when HI has the same value
for 2 or more items, then sort them descending by LOW

So far I can only arrange them by HI
and keep getting a table like this:

Number Name HI LOW
1 A 900 900
2 B 900 850
3 C 900 880
4 D 800 700
5 E 800 750

So, I need that C should be above B
and E above D

I have try the Z-A button on HI and then LOW
and also clicking on Number-More sort options-Descending by HI
but can't make the pivot table do what i want

is this possible??
I'm using EXCEL 03