Top 10 Filter

[NikkiR]

I'm trying to filter to the Top 10 sales opportunities however because the names of the opportunities have been entitled the same name they are being grouped together in the table.

So that I can get the individual opportunities, I have added the opportunity ID to the table and filtered on the top 10 using this field, however this field then appears in the chart I am creating.

Is there any way to hide this field in the chart but keep the name field? Or is there a better method than what I've been using?

 

[scottsen]

There is probably a way to handle this in straight excel, but I am lame at that I know in a pivot table, you can use the Value Filter to filter by columns that are not in the table... but I'm less sure on charts.

I suspect there is a path using TOPN as a filter to calculate, example (that I doubt actually works but gives the idea...)

Top10OppyDollars := CALCULATE([OpportunityDollars], TOPN(10, VALUES(Customers[OppyId]), [OpportunityDollars])