REPOSTING WITH EDITS: I am trying to get a column with the MINIMUM and the MAXIMUM monetary order values (G.T. Base) per person, split into the first order and the last order of the person itself.
Each person (Bill to name) has different orders and different value of orders (GT base). I calculated which is the FIRST order for that person and the LAST order for that person but I am not able to associate the monetary value (GT base) to that first order for that person and for that last order for that person. Please see example attached.
Aucun commentaire:
Enregistrer un commentaire