1 Reply Latest reply: Oct 4, 2011 8:02 PM by wms RSS

    Selection Box: Revenue Ranges

      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

        • Selection Box: Revenue Ranges

          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.