Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.