How to compute the marginal value with ActivePivot
How to compute the marginal value with ActivePivot From a dataset of transactions, I am trying to compute a marginal P&L, that is, the total P&L by product except for the contribution of a given buyer. Consider the following dataset: +---------+---------+--------+ | Product | Buyer | Amount | +---------+---------+--------+ | Water | Arthur | 10 | | Water | Georges | 25 | | Water | Arthur | 13 | | Water | Oli | 42 | | Wool | Oli | 150 | | Wool | Oli | 18 | | Wool | Simon | 70 | | Wool | Arthur | 20 | | Wood | Georges | 231 | +---------+---------+--------+ +---------+---------+--------+ | Product | Buyer | Amount | +---------+---------+--------+ | Water | Arthur | 10 | | Water | Georges | 25 | | Water | Arthur | 13 | | Water | Oli | 42 | | Wool | Oli | 150 | | Wool | Oli | 18 | | Wool | Simon | 70 | | Wool | Arthur | 20 | | Wood | Ge...