Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem and cannot solve it, I was wondering one of you guys can help me here.
I have a table like this and I need to find out how much is total value of sales orders under and above $2000. (Aggregated by sales orders not Sales order_Line)
Sales_order | Line | Value |
1935573 | 1 | $ 489.44 |
1935573 | 2 | $ 2,068.44 |
1935573 | 3 | $ 633.60 |
2190057 | 1 | $ 437.65 |
2242557 | 1 | $ 560.56 |
2190057 | 2 | $ 20,125.00 |
2238734 | 1 | $ 13,989.97 |
2240007 | 1 | $ 120.00 |
2240007 | 2 | $ 400.00 |
I am using this expression for above $2000 but it doesn't work:
=Sum(Aggr(Sum({<Value= {">=2000"}>}Value),Sales_Order,Value))
Thank you,
Hossein
This?
Sum({<Sales_Order = {"=Sum(Value) >= 2000"}>} Value)
add dimension like =if(aggr(sum(Value),Sales_order)>2000,Sales_order)
measure Sum(Value)
result
Thank you sunny. It works perfectly.
I am really surprise actually the way this expression works.