I have a stacked column chart to show revenue for each sales manager. The revenue columns are split by customer. How do I display the top 10 customers by revenue for each manager on the axis? I would like 10 companies' revenue for each sales manager column on my chart. All I have, so far, is the top 10 customers by revenue NOT per manager (10 companies total, split across the managers)
My fields are: accounts[Customer Name], opportunities[Revenue], and systemusers[Full Name]
Edit: A customer only one has sales manager assigned, so there should be 10 unique customers per sales manager.
Share some data and show the expected result. For now, do not both about the visual. Let's just compute the correct numbers in a simple Table visual first. Once we have that in place, we should be able to build any chart.
This is essentially what I am after, but the revenues are sums from the opportunities table relating to a company and each company has a sales manager assigned to it. Can't post actual data due to amount + sensitivity.
The current workaround I have is a Top 10 filter for company by revenue and then a slicer to filter managers. This way has a default view of total 10 companies and if you want to see one manager's top 10, then you simply select them on the slicer. I would love to show each manager's top 10 at once, but this will work for now.