16 Replies Latest reply: May 3, 2016 6:30 AM by Prasanta Kumar RSS

    Limiting bars

    Prasanta Kumar

      Hello Everyone,


      I am trying for a solution around how to limit the bars dynamically.


      In my below bar graph, i want to limit the bars to 2 based on customers sum(Revenue) in desc order.


      Dimensions - Customers

      Measure -





      Sorted expression - sum(Revenue) in desc order


      data handling - not showing zero values.


      any suggestion how to show only 2 bars for customers with sum(revenue) in desc order.


      thanks, please refer the attached qvf.






      Limit Bars.JPG