Skip to Content
0
Former Member
May 24, 2009 at 04:56 PM

Keyfigure aggregation

24 Views

I have a report (Report 1) which reports measures at Material level. Now user would like to see same report at Mat-Plant level (Report 2) and however want to keep measures same as Report 1. For example, %Total keyfigure is calculated based on complete shipments total (%GT). But this keyfigure displays different value in Report 2. Its calculation is correct based on report data but user wants to see different value. I tried using exception aggregation on shipments based on material, but it didnt affect calculation of %Total keyfigure. Any other way to achieve below output?

Report 1

Material Shipments %Total

      M1       100       50%

      M2       100       50%

Report 2

Material Plant Shipments %Total(Current) %Total(Expected)

      M1       P1       100       25%                   50%

      M1       P2       100       25%                   50%

      M2       P1       100       25%                   50%

      M2       P2       100       25%                   50%

-Abhijit