Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I want to group the total amount by order number;The issue is Qty1: No value through the first algorithm,and Qty2: aggr( nodistict()) No grouping by order number;
Do you have any idea?
Thanks,for any help in adavance.
Best regards !
What exactly is the output you are hoping to see?
The Qty2 result is wrong,It counts the article number instead of the order number, and the Qty1 expression written has no value
What are the numbers you expect to see in the chart?
That is the Qty2 result ;Qty1 Should be a grammar question,but I cant find the problem;
@
Please see attached. I changed the approach to no longer use a ValueList() but rather an Aggr() to create a calculated dimension. This significantly simplifies the expressions for the measures. There is an additional chart in the attachment showing this.
Hope this helps.