3 Replies Latest reply: Dec 5, 2016 3:43 PM by Lefteris Zampoulakis RSS

    Aggr and then count distincts

    Lefteris Zampoulakis

      Hi

       

      I want to calculate a KPI to show the number of orders with total quantity no more than 100 units. However my data is in order line level and needs to be aggregated first. I am assuming a combination of aggr and count distinct but can't really structure the formula.

       

      OrderOrder lineUnits
      A150
      A240
      A320
      B120
      B210
      C18
      C240
      C320
      C43

       

      Thanks in advance