3 Replies Latest reply: Feb 5, 2015 10:16 PM by jagan mohan rao appala RSS

    How to do filter before description

    Jelly CHEN

      Hi All,

       

      Now I have a set of data in QV, just like the following table.

      EmployeeSaleMonth
      A50Jan
      A150Feb
      A250Mar
      B270Jan
      B160Feb
      B60Mar
      C140Jan
      C40Feb
      C280Mar

      I would like to create a description chart, each employee only could be calculated one time. dimension is sales group ("<100","100<= and <200", "200<= and <300"), expression is number of  employee. Before those condition, How could I modify dimension or expression?

       

      If I use normal way, QV would give me this result:

      Sales GroupNumber of employee
      <1003
      100<= and <2003
      200<= and <3003

       

      But I would like to distinct employee and choose the min(sale) first and then get the following result:

      Sales GroupNumber of employee
      <1001
      100<= and <2001
      200<= and <3001

       

       

      How could I get my prefer table?