Hello Excel forum members and good morning from Denver, CO!
I am new to this forum. I typically research my Excel conundrums before I reach out but honestly I cannot put my thumb on this. Do forgive me of my Excel ignorance, I've worked with IF formulas and created several spreadsheets in the past however, I never learned the correct vocabulary to use when it comes to Excel processes.
I have attached a PDF of the excel sheet that highlights the goals and the issues that I am having as well as the test excel sheet.
Synopsis: I have created a table labeled as 'Monday' on the 2nd sheet that incorporates names, dates, reg. time hours, reg. time cost codes, OT hours, and OT Cost Codes.
Issue: Once the pivot table is created and I incorporate the reg. time w/ costs codes and OT w/ cost codes, the table wants to sum both under the same row instead of separated those hours with their respective cost codes.
Goal: Create a pivot table on the first sheet that sums the reg. time and reg. time cost codes and OT time and OT cost codes separately. (Filter could be name, week ending, etc. That's the easy part)
I hope I explained that well. Thank you for the help!!
Bookmarks