Forum Discussion

BrianaHop's avatar
BrianaHop
Icon for Helper I rankHelper I
6 years ago

Help with TopN Slicers

I have a report that shows Salesperson performance with columns for our 4 key performance factors: Units Sold Total Volume Sold % of Sold Refinances based on Units % of Sold Purchases based on U...
Need Help
BrianaHop's avatar
BrianaHop
Icon for Helper I rankHelper I
6 years ago

lbendlin the issue is that I need to see the full data first and then drill down. It's important to see the entire team to gauge performance and then drill into each KPI. Volume and Units are the KPIs and the %s are really more of the sort options if I'm simplifying things. I want to cut down to the top 20 volume -or- units and then sort by % of loan types. So I want to see the top 20 performers and of only those 20, I want to know who has the highest ratios. I have thought about using bookmarks but wanted something that takes up less space. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi BrianaHop ,

Could you please provide some sample data (exclude sensitive data) and your expected result in order to provide you a solution which is suitable for your scenario? In addition, please review the following links and hope they can help you.

Top N visual-level filters

RANK/ TOPN with slicer

Best Regards

Rena