Pivot Chart - Sort by Multiple Regions

[#1]

I'd like to see the top 20 Product Numbers ranked by Net Sales in each of our Retail Regions. We have 4 different Retail Regions, so in the end I want to see 80 Product Numbers ranked by Net Sales in descending order, and there should be 20 from each.

My Dimensions are Retail Region, Product Number, and Product Description.

I can't figure this out for the life of me. Thanks in advance for help and please ask any questions if I didn't offer enough info.

Thanks,

Mike

[pover]

In QV, the sort is over global numbers so you can't have a different sort order of products being shown depending on the region in the same pivot table.  You would have to divide it into 4 different pivot tables and use set analysis specify the region for each table.

Also, if this is important for you, vote on the idea to add it to QV (http://community.qlik.com/ideas/1250#comment-2063)

Karl