Good Morning,
I have a spreadsheet that tracks time spent on various categories. There are 3 sheets:
1. Time Tracker: This is where employees will document their time including, day of the week, start time, end time, category & duration (Hours)
2. Calculations: This is where the duration for each activity & day will be summarized into a table separated by Months
3. Pivot: This is where the supervisor will be able to view how much time an employee has spent on various categories based on the selected days.
The issue is that, when multiple dates are selected or placed into the Values field, the pivot table is not updating to reflect all selected fields. How can this be fixed?
I apologize for any missing information as I have not posted here for a while. Please let me know if you have questions.
I have included a spreadsheet for reference.
Bookmarks