2 Replies Latest reply: Oct 30, 2017 9:50 AM by omar bensalem RSS

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

    celine xu

      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)