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