Dear Excel gurus!
I am trying to tackle a task that may be easier than I think, but I do not see the solution.
I have two tables.
One with all my customers (every customer has a unique code) and all the orders with unique articles they order and the net sales generated. If I add that table to a pivot I can see the Net sales by customers, by brand or by articles. I add slicer and have the figure showcased in a CELL: "NET SALES" (use the =getpivotdata function).
I have another table with all my customer plans. It is not on article level, but on brand level. One number for every customer for both brands (in the example).
My goal is to show the PLAN next to the NET SALES if I filter to a customer. If the filter is set to one Brand, it should show the PLAN on Brand level, etc, etc.
I uploaded an example excel:
(if I use the slicer the PLAN should update as well regarding the selection.)
I hope I explained it clearly, please let me know If i need to be more specific, let me know and thank you for your help in advance.
Csanad
Bookmarks