Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Expression, something like:
=Sum({<InvoiceNo={">=$(vMin) <=$(vMax)"}>} Amount)
The range of values have to be the invoice amount.
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?
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