This content has been marked as final. Show 3 replies
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.
Thanks in advance