DP sum with aggregation level

[Former Member]

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.

[Former Member · Accepted solution]

hi Alexander

You could also consider using realignment for achiving the desired result. You can use the addition logic to add the data from the source CVC to the destination CVC so that sum is displayed on the CVC. you can read more on alignment on the below link.

http://help.sap.com/saphelp_apo/helpdata/en/c7/cf8f39bab68350e10000000a114084/frameset.htm

Let me know if this helps.

Thanks, Sandeep

[Former Member · Accepted solution]

Thank a lot! That's exactly what I needed!