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 -

      if(((sum(Activity1)+sum(Activity2)+sum(Activity3)+sum(Pcost)+sum(Tcost))/sum(Revenue))>.1,

      ((sum(Activity1)+sum(Activity2)+sum(Activity3)+sum(Pcost)+sum(Tcost))/sum(Revenue)),

      0)

       

      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