Slider to Select a Range of Values

[tmumaw]

Hello All,

Question for you.  I have a slider where I want to be able to select all Invoice Gross sales between selected values on a slider.  I have setup two variables $vMin and $vMax.  Where I am getting lost is on the expression to only sum the ones between the ranges on the slider.  Any help?  ....

Thanks

[tresesco]

Expression, something like:

=Sum({<InvoiceNo={">=$(vMin) <=$(vMax)"}>} Amount)

[tmumaw]

The range of values have to be the invoice amount.

[Anonymous]

i may be missing something here, but if your slider has the amount and you are trying to display the sum of amount based on your selections on the slider, then a simple sum(amount) or sum(distinct amount) should do, no?

[tmumaw · Accepted solution]

This is what I needed to do.  First here is what I put in for my dimension:

If(aggr(sum({Inv Gross]),[CustRankKey]) >= $(Max) and aggr(sum([Inv Gross]),[CustRankKey]) <= $(Max1), [CustRankKey]), then my measure was if(sum([Inv Gross] >= $(Max) and sum([Inv Gross]) <= $(Max1),

     (Sum([Inv Gross]))).

Thanks everyone for your help.

Thom