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