We currently have an ODS-object where we have a volume figure and the characteristics 'Customer' and 'Material'.
Currently we get the volume per customer and per material.
For further calculations we would need this volume figure as
(1) a total for all customers and
(2) a total constant volume for all customers and products.
Customer | Material | Volume
AAA | 123 | 60 TO
BBB | 234 | 100 TO
BBB | 566 | 20 TO
CCC | 987 | 50 TO
Customer | Material | Volume| Volume (cust)|Volume (tot)
AAA | 123 | 60 TO | 60 TO | 230 TO
BBB | 234 | 100 TO| 120 TO | 230 TO
BBB | 566 | 20 TO| 120 TO | 230 TO
CCC | 987 | 50 TO| 50 TO | 230 TO
Is this possible to do within the same ODS and how?