Skip to Content
0
Former Member
Feb 27, 2006 at 09:58 AM

Total key figures for calculations needed

13 Views

Hi all,

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.

Example:

Currently

Customer | Material | Volume

AAA | 123 | 60 TO

BBB | 234 | 100 TO

BBB | 566 | 20 TO

CCC | 987 | 50 TO

Wanted

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?

Thank you!