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 want to be able to show the top 10 region that have the biggest increase or decrease (and thus filter out the rest (others) that are in between). I want to show on my dashboard the numbers next to the chart and thus I need to be able to filter for my top 10 with 1 single filter. As this is a calculated field, I cannot select "apply to worksheets" and imply select the ones I need. Also, with actions I'm not able to get the result I need. Hopefully someone out there is able to guide me on this.

 

Also, as I nice add on, how can I hide in my chart the "difference in sales" column for the year that is empty in my chart sheet?

 

use calculated field as a filter on a dashboard to drive 2 sheets 

2 个回答