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.
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.
