Hi,
This is what I need:
1) In the sheet 1, should have dates & names of employees (Like in the attached sheet)
2) If a person is present, the cell is "1", if the person is absent, the cell is "0".
3) Need to calculate the daily outage% (using Pivot only)
i.e. I need to calculate the (number of people attended)/(total number of people)
This needs to be a "CALCULATED FIELD" in the pivot.
Bookmarks