Hello,
I am trying to build a dashboard on the time keeping. So, the raw data has header such as Date, Categories, Hours and Sites. Under the Categories, we have "OT, "NT" and "Abs" and under Sites, we have MW, NC, and WE.
So, I have to find out the total of Over time, Normal Time and Absent time in percentage. To calculate the % of OT, here is the calculation OT/(OT+NT). Now, my problem is, on the pivot table, the OT, NT, ABS are items but not field. So, I could still calculate the items but then after I got the calculation, I won't be able to group the date month, quarter and year. Anybody has any idea what should I do, I'm so frustrated.
Thank you.
I am trying to build a dashboard on the time keeping. So, the raw data has header such as Date, Categories, Hours and Sites. Under the Categories, we have "OT, "NT" and "Abs" and under Sites, we have MW, NC, and WE.
So, I have to find out the total of Over time, Normal Time and Absent time in percentage. To calculate the % of OT, here is the calculation OT/(OT+NT). Now, my problem is, on the pivot table, the OT, NT, ABS are items but not field. So, I could still calculate the items but then after I got the calculation, I won't be able to group the date month, quarter and year. Anybody has any idea what should I do, I'm so frustrated.
Thank you.