2 Replies Latest reply: Jun 10, 2011 2:43 PM by yaman1510 RSS

    Define Range..? What all functions can be used?

      Hello Everyone,

       

      I have a spreadsheet where I have records of 1000 employees working in a company. Now I have to draw a chart where I have to define range, like i have to differentiate between data of 2009, 2010 and so on. It's a smple question but I am not able to figure out the expression.

       

      So , each employee has a Age column linked with its record. How can we divide the Age based on range? example out of 1000 employees we can divide:

       

      21-25-- 100

       

      25-30-- 200

      30-35-- 250

       

      35 above ---500

       

      So I have to design a Stacked bar chart , where Dimension would be Year. and then expression would be the count of employees based on range defined above, What calculated expression can I design? Please reply.

       

       

      Thank you.

       

      Best,

      Yaman