I’m trying to create a dashboard please see the attached.
I have got on sheet 2 two graphs that are linked to the slicer next to it so that when you change to a different client it updates the two graphs.
What I’m struggling with is below in cell D32 I have a few stats I need to update depending on the slicer.
So for example when the slicer is on Client 1 I won’t it to update the stats for total calls, service duration etc for that client, and when I click client 2 on the slicer I won’t the figures change to client 2s data.
Hope I have explained this properly.
Bookmarks