8 Replies Latest reply: Dec 19, 2017 3:16 AM by kong ch RSS

    Help: maximum from each count

    kong ch

      Dear all,

       

      I would like to set the formula to get the maximum from each count as below.

       

      Result

      TypeEachCount
      ABC13

       

      can anyone share the idea?

       

      Thank you so much

       

       

      Table column 

      Type

      (database column)

      Order Date

      (database column)

      EachCount

      (it is calculated measure, not in the database)

      ABC29-Sep-201713
      ABC19-Oct-201712
      ABC03-Oct-201711
      ABC21-Oct-201710
      ABC10-Oct-20179
      ABC12-Oct-20179
      ABC17-Oct-20179
      ABC20-Oct-20179
      ABC23-Oct-20179