Need help setting up an Attendance Tracker

[Nikhil Raj]

I have attached here an attendance tracker that I maintain.

Now using Pivot Table I want to pull data in regards to information for each employee. I need to know the no of leaves he has taken in a particular month as well as on a total basis.
Also I need to know how many morning/afternoon shifts they worked in a month as well as on a total basis.


Please help if possible.