In this table we work on Prod_Id as a first level, then Empl_Id and at last Cust_Chain.
The goal is to see per product, in which chain of customer each employee , has checked how many stores have this product present (#Presence) and how many stores they still have to check for this product to reach their target (To Do).
This pivot table is working well and to the satisfaction of the client.
But! And here it comes, the client wishes for an exception for product SL0051 (not any other product, those have to remain the same), that only user RSS07 (not any other user, they also have to remain the same) gets an additional Cust_Chain, Carrefour Express.
By changing my variable, I'm able to include this new chain without any issue. But the difficulty lies that this chain is automatically added for all products and all other employees
The expression used for example in column Maximum Distribution, for the original table is: