5 Replies Latest reply: Jun 8, 2018 9:54 AM by Eduardo DImperio RSS

    Help to crescent order a table

    Eduardo DImperio

      Hi,

       

      I need to order my table, but i don't understand why can't i do this.

       

      Dimension:

      CAUSA

       

      Measure1:

      Count(CAUSA)

       

      Measure2:

       

      Rangesum( Above( COUNT(CAUSA)/count( ALL CAUSA),0,Rowno(Total))) 

       

      Table:

       

      set_analysis.JPG

        • Re: Help to crescent order a table
          kaan erisen

          Hi Eduardo,

           

          When you add rangesum(above..) expression to table or table equivalent chart, you can not do ordering over other measures, not dimensions. Dimensions keep working on ordering.

           

          But you can order over measures by using a workaround. Define your measures like a dimension. I know it not the best practice but it is working as you wish

           

          Sorted over first dimension:

          Untitled.png

           

          Sorted over measure and not working:

          Untitled2.png

           

          Sorted over a dimension which is created to show measure value and working:

          Untitled3.png

           

          You should edit your rangesum expression a bit after making these changes

           

          RangeSum(Above(total sum(QTY)/sum(total QTY),0,RowNo(total)))

           

          P.S : After creating this dimension, you should also change its ordering type from auto to custom(Sort numerically) over table properties panel.

           

          Hope it helps...