Hi guys,
I have included the 'example' workbook for you guys too see.
Basically, I have the raw data sheet that has small 'tables' for each week. I want to have a pivot table and/or chart that allows me to sort by week and see in a particular week, how many are late because of 'sick', how many are 'LS'... And ultimately create a chart that I can filter by week to see the percentage of each late reasons given the particular week.
Please let me know if this make sense!!
Thanks again for you guys' help!
example.xlsx
Bookmarks