I have a report page with a slicer on sales exec and lots of performance charts. All good.
I have used the ALL function to get the team amounts against his. Just fantastic.
My problem is I’d like a card showing the top performer in the team. I’ve tried:
- Topn with Top1 (having watched Sam’s videos) but they just identifty the amounts and it’s the name of the top sales exec I need in the card. So how do we get the Top sales exec name onto the card.
- I also tried creating a small table to try and id top sales exec instead of a card but it just shows the filtered sales exec even when I hit the non button on the sales exec slicer??
Any ideas here?