Aggr Sum

[bellesol]

Hi,

I have the following table:

Product	OrderID	Type	OrderSum$
A	1	1	100
A	1	1	200
A	2	1	500
B	4	1	600
B	4	2	100
B	5	1	800

I would like to calculate the sum of "OrderSum$" group by "OrderID" which the sum of the order is bigger then 400$ and the type of the order is 1 and display it by "product" -

for example: Product "A" has 2 orders the sum of orderID "1" is 300$ and the sum of orderID "2" is 500$, so only orderID ="2" should be displayed because the sum of the order is bigger then 400$

the final table should look like:

Product	OrderSum$
A	500
B	1400

I attached QVW for example.

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(
  If(Sum([OrderSum$]) >= 500, Sum([OrderSum$]))
, Product, OrderID))

[lironbaram · Accepted solution]

hi 

this expressions should work for you 

sum(aggr(if(sum({<Type={"1"}>}OrderSum$)>400,sum({<Type={"1"}>}OrderSum$)),OrderID,Product))

[bellesol]

Thank you all!