Limit the value...

[#1]

Hello,

Below is my sample data .

Region     Cost

NA           100000

LATAM       90000

EMEA        60000

APAC        40000

I want to display cost by Region in bar chart but should have an option to toggle between regions with cost more than 75 k and regions with cost less than 75 k.

Is this doable at all ?

Thanks much.

[sunny_talwar]

Sure thing. May be using a variable called vVar, create an expression like this:

If(vVar = 1, Sum(Cost), If(Sum(Cost) > 75000, Sum(Cost)))

[sunny_talwar]

Sample attached