6 Replies Latest reply on Sep 22, 2015 7:46 AM by jasmine.s

    How do I get the count of each category and total at the end

    jasmine.s

      Hi All,

       

      I have a requirement wherein I have to sum the no of hours for each employee  separately as morning and evening  and have a total on that. a pictorial representation is shown as below. I got the count of the hours for each employee but I am not able to separate by morning and evening. I have created a calculated field for morning (like from 9am to 9pm then morning) evening ( from 9pm to 9am ). Now how do I segregate these based on the hours

      query.png

      Please advise ....

      Thank you