Pivot TAble: Loop through Totals Column and hide

[argledhel]

Hi guys!

I'm trapped in a what I think is a simple-to-solve-problem (though it is too much for me, haha).
I need to check for the 9 highest values in the totals column (marked yellow) and group the rest.
But I don't know how to loop through that it.

At first, I sorted the table through the totals columns (marked yellow) and I though I could loop through the pivotitem (APPLIANT) of the rows, but it does not loop as displayed, but loops instead according to an alphabetical order.

Filing.jpg

Hope you can help me!