Bar chart, choose top 10 product name but eliminate the empty name

[Anonymous]

Hi,

Here is the graph showing the bar chart I want to create.

There are more than 10,000 product name'ProductName', I want to only show top 10 or 15 in the graph in terms of ''Sum(NumberUniteSold)''

at same time eliminate the one with 'ProductName'

How could i do that?

Thank you.

was using follow function in the DATA --> Measure place:

=Aggr(If(Rank(Sum(NumberUniteSold),4)<=10,ProductName,ProductName)

[OmarBenSalem]

Your have a dimension: called "Product Name" that has a value = "Product Name" that you want to eliminate?

If this is the case:

As a dimension: choose product Name and limit it to the first 10/15 :

as a measure:

sum({<ProductName -={'Product Name'}>}NumberUniteSold)

[OmarBenSalem · Accepted solution]

if you want juste to eliminate the empty name:

choose the same dimension and uncheck this:

just use your simple measure : sum(NumberUniteSold)