How to list top item combinations from a table or pivot table?

[David Teitelbaum]

Hi, I have a pivot table that contains two variables, Flavor 1 and Flavor 2; there are multiple entries for each variable, like fruit flavors for Flavor 1 and candy flavors for Flavor 2. I then have numerical values for each flavor combination.

I want to list the combinations in descending order of values, so what I want to see is something like the following:

mango caramel 53
banana caramel 22
banana chocolate 13
strawberry chocolate 12
...etc

I can't figure out how to rank and display the combinations.

Can you help?

Thank you!!

David

 

[NARAYANK991]

Hi David ,

See if this is OK.

Narayan