Need Between drop down selections

[#1]

Hi Champs,

I have a requirement in which user should be able to select Revenue Between:

Revenue From (In Drop down)

Revenue To (In Drop down)

Please refer the attached Image.

I have a table box below the drop down selection in which the data should be filtered based on the Revenue range selection.

Can you please help me on this?

Thanks,

Praveen

[giakoum]

Hi.

use 2 variables, add them to sliders for the user to choose range. Then use those expressions in a set analysis or if statement in your expression in the table, kind of like :

if(sum(value)>=bottomLimit and sum(value)<=topLimit, sum(value))

[#3]

Hi,

Business users are not intrested in the slider.They are expecting the Drop downs only.

Thanks,

Praveen

[giakoum]

Then add them in a list box with predfined values.

[kiranmanoharrode]

Dear Pravin,

Make 2 Inline Fields and Add your Specific records in those fields.

Then create 2 variables

vMin=Max(SalesFrom)

vMax=Max(SalesTo)

then Use Set expression.

=Sum({<Sales={">=$(vMin)<=$(vMax)"}>}Measure)

Regards
Kiran Rode

+91 8976977897

[#6]

Hi Kiran,

Can you please help me with an example.

Looks like I can't go with the set expression because after the Revenuew From and To selection...I would be seeing the list of companies thier state,city,zipcode..etc details.Am not showing any measures there.

Please let me know how can I use it.

Thanks & Regards,

Praveen Palle

[#7]

Hi,

Can anyone please help me with an example...need only drop down here.

Looks like I can't go with the set expression because after the Revenuew From and To selection...I would be seeing the list of companies thier state,city,zipcode..etc details.Am not showing any measures there.

Please let me know how can I use it.

Thanks & Regards,

Praveen Palle