SUM the value in text Object

[bkn]

CODE is the Dimension and TOTAL is expression. I wan to get only the Total value which is great than $50. I want to get that $75 value in the Text Object.

Thanks in Advance.

[vishsaggi]

May be try this in your text box

= Max(Aggr(Sum(YourTotalfield), CODE))

[bkn]

Data is dynamic, i need to get the value of Total which is greater than 50  in text object. for e.g. 266 from this image.

Thanks in Advance.

[vishsaggi]

Try this in your textobject

= Sum({<Totals = {"=Totals>=50"}>}Totals)

[bkn]

Appreciated. It works. 

Thanks.

[vishsaggi]

Oh great. Got it now. Please closed the thread marking correct helpful responses.