Aggr question

[hossein_heydarniya]

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

[sunny_talwar · Accepted solution]

This?

Sum({<Sales_Order = {"=Sum(Value) >= 2000"}>} Value)

[dplr-rn]

add dimension like =if(aggr(sum(Value),Sales_order)>2000,Sales_order)

measure Sum(Value)

result

[hossein_heydarniya]

Thank you sunny. It works perfectly.

I am really surprise actually the way this expression works.