
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!
see the red tabs - I used lods based on the 2 years to determine the diff and used that to sort the data
Thanks
Jim - Tableau Visionary