New Member
September 10, 2019
Hello all,
I have an interactive dashboard that I built that has a slicer with each sales reps name. Its a pretty simple dashboard with their sales metrics but on the bottom of the dashboard is their income potential filled in with their current metrics. Next to those pre-populated cells are empty cells where we can adjust certain %'s to see the impact it would have on their individual income. What I would like is for the cells that we input the potential numbers into stay with those numbers for that particular slicer selection (sales rep) and not change all of the other sales reps. I am not sure if this is possible or not but i figured I would give it a shot. I put a screenshot below. The light blue cells at the bottom are the ones I want to fill in manually. I have put red fill in a few areas that display the sales reps full names for privacy. Any suggestions?
July 16, 2010
Hi David,
Welcome to our forum!
When you change the Slicer selection, what do you want Excel to do with the values you typed into the blue cells? Clear them? Save them somewhere? I'm not saying this is possible, I'm just trying to understand what you'd like to happen in an ideal world.
Mynda
1 Guest(s)