Need help - Analysis on the Daily Attendance in Excel Pivot

Hi All,

I just joined to this Forum today expecting the healthy conversations & resolving each other issues. I work for a company as an Project Manager.

Kindly help me with the attached sample file with Attendance details to get the pivot/chart to know the % or Count of Working, Leave & attrition. Thanks.

Below is my Format as I am unable to upload the excel file.

Ex 1 :

Emp ID Name of Employee City Area 01-04-20 02-04-20 03-04-20 04-04-20
A123 ABC Bangalore Kormangala Work from home Leave Leave Work from home
C123 DEF Bangalore Vivek Nagar Leave Work from home Work from home Work from home
D123 GHI Chennai MG Road Work from home Work from home Leave Work from home
E123 JKL Chennai Ananthpura Work from home Work from home Work from home Attrition

Ex 2:

EmpID NameofEmployee City Area 01-04-2020 02-04-2020 03-04-2020 04-04-2020
A123 ABC Bangalore Kormangala Workfromhome Leave Leave Workfromhome
C123 DEF Bangalore VivekNagar Leave Workfromhome Workfromhome Workfromhome
D123 GHI Chennai MGRoad Workfromhome Workfromhome Workfromhome Leave
E123 JKL Chennai Ananthpura Workfromhome Workfromhome Workfromhome Attrition



Regards,

Shiv

Hello Shiva01,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Hello Shiva01 and Welcome to Excel Forum.
You have posted your question in a forum that is set up for introductions, not providing answers to questions. Please repost your question (you could copy it) in one of the Microsoft Office Application Help - Excel Help forums.
I will also mention that there are instructions for uploading an Excel file in the banner at the top of the page.
Let us know if you have any questions.