Pivot Table Sorting

[Ciara]

Hi All

I'm finding the pivot table sorting a little tricky and need some advice.

I have 2 dimension - Inventory and StockNumber

I have 3 measures - Vendor 1 Value on Hand, Vendor 2 Value on Hand, Variance (between V1 and V2)

I have no problem sorting the Inventory descending by the variance, but when I expand on an inventory, the I cant quite figure out how to sort descending on the variance here.

Can anyone help?

Much appreciated

Ciara                                            

[brunobertels]

Hi 

May be use aggregate function aggr() by Inventory and rank fonction rank() in it to class the rank of variance BY inventory