K
kevlowe1
I need help setting up a pivot table that counts from two columns. I
have an Access database that tracks the work orders performed by my
mechanics. Currently, I import this into excel. What I want to count
is how many work orders in a day a mechanic works on. There can be up
to 2 mechanics that perform a work order so I have two columns names
Mechanic #1 and Mechanic #2. When I set up my pivot table with the
Mechanic #1 and 2 as column fields, the date as the row field, and the
count of the word order # as the data field, the pivot table returns
the count of the combinations of occurences of the names in the
mechanic columns vice the number of occurences that that particular
name appears in those columns.
have an Access database that tracks the work orders performed by my
mechanics. Currently, I import this into excel. What I want to count
is how many work orders in a day a mechanic works on. There can be up
to 2 mechanics that perform a work order so I have two columns names
Mechanic #1 and Mechanic #2. When I set up my pivot table with the
Mechanic #1 and 2 as column fields, the date as the row field, and the
count of the word order # as the data field, the pivot table returns
the count of the combinations of occurences of the names in the
mechanic columns vice the number of occurences that that particular
name appears in those columns.