Need Help

[paulwalker]

Hi Community,

I have one requirement,

table:

Name, Cost

X, 2000

Y, 3500

Z, 1230

A, 6000

B, 4566

C, 3450

Suppose i have one slider Min(cost) and Max(cost), i want to create variable..

if i am move my slide.. i want show in between data in my Chart...

suppose my slider 2000 to 3000, i want return..

Name, Cost

X, 2000

Z,1230

Hope you Understand..

Thanks in Advance...!!

[paulwalker]

suppose if i create vMin= Min(Cost)

vMax= Max(Cost)..

How to pass variables in expression??

[sunny_talwar]

Your expression needs to be like this:

If(Sum(Cost) >= vMin and Sum(Cost) <= vMax, Sum(Cost))

[sunny_talwar · Accepted solution]

Please find attached a sample: