[SOLVED] Question to "sum" aggregation when Pivoting
Hi,
I'm trying to create a rather simple Pivot Table using the "Pivoting" operator.
Let's say this is the raw data:
(Note: I initially posted the wrong raw numbers in the third row, but it's corrected now.)
The Pivot operator is configured as follows:
Group Attribute: Customer
Index Attribute: Article
Weight Aggrecation: sum
When I run the process, I get this result:
However, I would have expected this:
Could somebody help me to understand what I'm doing wrong?
I'm trying to create a rather simple Pivot Table using the "Pivoting" operator.
Let's say this is the raw data:
| Customer | Article | Amount | Quantity |
| C1 | A1 | 100 | 10 |
| C1 | A1 | 150 | 15 |
| C1 | A2 | 200 | 20 |
The Pivot operator is configured as follows:
Group Attribute: Customer
Index Attribute: Article
Weight Aggrecation: sum
When I run the process, I get this result:
| Customer | Amount_A1 | AmountA2 | Quantity_A1 | Quantity_A2 |
| C1 | 150 | 200 | 15 | 20 |
| Customer | Amount_A1 | AmountA2 | Quantity_A1 | Quantity_A2 |
| C1 | 250 | 200 | 25 | 20 |