on 01-16-2019 1:04 AM
I am trying to do a Sum of quantity for products, using HANA Calculation Graphical View.
<code>MATNR | MENGE
AAA | 1
AAA | 2
AAA | 2
BBB | 2
BBB | 3
Using aggregation node, I choose MATNR as normal output and MENGE at Aggregated Output.
The result is, MATNR AAA always shows 3 which is not correct (BBB is 5, correct).
I tried set the source view to CUBE, change MATNR to attribute (and make it KEY field), also change MENGE to measure. Every suggestion I have read but no luck.
I understand that aggregation node auto groups the same value before Sum. How do I avoid it and get correct result for MATNR AAA?
Thank you
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.