13 Replies Latest reply: Apr 22, 2016 12:39 AM by Prasanta Kumar RSS

    Sorting and limiting bar chart

    Prasanta Kumar

      Dear All,

       

      Please find attached a qvf, i which i want to limit the bars as below.

       

       

      In Gross Margin bar chart

      -> i want to show only those bars when its value is greater than 10%

      -> want to Sort those bars by expression sum(Revenue) and llmit the bar nos to 2 only.

      -> Dont want to use the filters, hence automatically wants to show the result for max(fmonthCD)

       

      can you please guide here.

       

      Sorting and limit.JPG