I'm about to build a dashboard which shows cost per department in a bar chart. Basically, I want to have a slider at the bottom which is a % from 0 - 100%.
As I adjust the slider, I want the costs to change (e.g. to show 60% of total costs). Does anyone know if this is possible? I would share a workbook, but I'm yet to receive the data for this and I'm just brainstorming what may or may not be possible first.