Top 10 by Revenue for Each Respective Axis Category

[MitchC3]

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.

[MitchC3]

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.

[Ashish_Mathur]

Hi,

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.

[MitchC3]

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.

[Ashish_Mathur]

Hi,

I will defnitely need some data to work with.