need expression with condition

[#1]

creating bar chart

dimension =  Customer Name

expression= sum(sales)

what I need

  SUM(Sales) range from 100 to 1000000

     i need only greater than 40000 only

any one can help me please?

[Anonymous]

sum (  { <range={>=40000}  >}   sales)

[sunny_talwar · Accepted solution]

May be like this:

Sum({<[Customer Name] = {"=Sum(Sales) > 40000"}>}Sales)

[sunny_talwar]

Or you can always do like this

If(Sum(Sales) > 40000, Sum(Sales))

[#5]

says error in set modifier and hoc element list

[#6]

it works. thank you

[Anonymous]

sum (  { <range={'>=40000'}  >}   sales)