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?