Skip to main content

Hi all,

 

please see my workbook attached.

 

Basically what I want to do is compare sales from year to year and calculate the difference per region. I'm using a parameter to show either top 5, others or bottom 5 regions. However, when comparing sales from other years (basically whatever I filter or do that changes the values of difference in Sales), I first need to see all regions in the parameter, do a column sort on difference in sales on both the tabular sheet and the chart sheet, and only then filter out the 'others' so that I can see the top and bottom 5 regions.

 

Any advice on how to get rid of this cumbersome process? Is there a way that the sorting can be done automatically? I can really use some guidance on this. Thanks so much already!

 

 how to avoid sorting on column headers when using parameter to show top and bottom 5 sales when they are compared year to year? 

7 answers
0/9000