Hi,
I have this set analysis
=aggr((only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Quantité requise]) - only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Quantité reçue])) *
only({< Année = {'2016','2017'}, [Statut de la commande] -={'4'}>}[Prix unitaire réception]), Nom, [Description du bon de commande], ld)
Basically:
For a Supplier (Nom), that has an order (Description du bon de commande), there are items (ld).
For each item I want to substract what I have received to what I ordered, and multiply that by unit price.
I thought AGGR would return the sum for the supplyer. But that only works if there are item per order...
What should I be doing?
I don't want to rework the model right now.
