Very new to pivot tables!!! I have looked, read, and searched and to no avail I cannot seem to find the solution. So, now I turn to the experts.
The situation:
I have a table that shows: Column A = Date; Column B = Tag Number; Column C = Full Time Equivalent 1; Column D = Full Time Equivalent 2; additional data to the right of Column D.
Employees have been placed in both FTE 1 and FTE 2 columns. For example, Mickey Mouse on one day is placed in FTE 1 position, while on another day Mickey Mouse is placed in the FTE 2 position.
How can I get the number of times Mickey Mouse is in both FTE 1 and FTE 2 positions combined? Is there an easy way to do this? For example, I want to create a pivot table based on a value in Column F, but I want the total times Mickey Mouse was listed in both columns.
Any help is greatly appreciated.
Bookmarks