Skip to Content
0
Former Member
Dec 12, 2011 at 11:54 AM

DP sum with aggregation level

42 Views

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.