2 Replies Latest reply: Nov 1, 2016 2:39 PM by Bella Mae RSS

    Grouping Results

      I have these columns:


      Employee IDDatesLocation
      1231/1/2016San Jose
      1231/2/2016San Jose
      1231/6/2016San Jose

      I want a Table that shows me data in this format:

      Location NameEmployees with more than 2 days of travel in Location
      San Jose1

      I am struggling with the last column 'Employees with less than 30 days of travel'. Can someone help?