Selection Box: Revenue Ranges

[#1]

Hi All,

I have an excel with records of companies, regions, employees and revenues with 400.000+ records.

I want to create selection box with revenue ranges to be able to see wich companies fall between a given revenue range.

Wich is the best way to achieve my goal?

Thanks in advance.

David

[#2]

Are revenues already aggregrated?

If so, you could use interval match.

///Assume a table with the field Revenue already exists and the following should make sense

inner join intervalmatch (Revenue)

LOAD * INLINE [

    START, END, Revenue

    0, 10, 0 - 10

    11, 20, 11 - 20

    21, 30, 21 - 30

    31, 40, 31 - 40

    41, 50, 41 - 50

    51, 60, 51 - 60

    61, 70, 61 - 70

    71, 80, 71 -80

    81, , 81 +

];

If you don't have revenue aggregated in script, you could use set analysis with variables. 

My set analysis skills are limited but I am sure there are examples around.