In DP I have a history of sales loaded at various plants in the keyfigure 9AVHISTORY. For example, the product 10 has the sales history in the plants 1001, 1002 and 1003.
How to use a macro, or something else, I can get the amount of the sales history of all plants on a characteristic combination of product 10 plant 1001?
Input:
Sales history:
Product 10:
Plant 1001 - 100
Plant 1002 - 300
Plant 1003 - 900
Desired result:
Product 10:
Plant 1001: 1300
Will be useful for any information on this topic.
Using Macros \ copying TS \ something else.