O
Os
I have two pivot tables that pull data from Access dB.
This is for a warehouse productivity and accuracy. Each
team consists of two employees: Picker and Loader. We
need to track employees accuracy when it comes to loading
cases. Both members of a team receive the same percentag
when working together. But many times different teams
have different members. I set up one pivot table that
shows cases by Picker, and another table that shows cases
by Loader. But I need to show the employee overall
accuracy. In other words I need to combine all their data
together and get one perecntage whether they picking or
loading. By the way, the data entered into two different
fields in the table (pickerCases and LoaderCases)
Any help is greatly appreciated.
This is for a warehouse productivity and accuracy. Each
team consists of two employees: Picker and Loader. We
need to track employees accuracy when it comes to loading
cases. Both members of a team receive the same percentag
when working together. But many times different teams
have different members. I set up one pivot table that
shows cases by Picker, and another table that shows cases
by Loader. But I need to show the employee overall
accuracy. In other words I need to combine all their data
together and get one perecntage whether they picking or
loading. By the way, the data entered into two different
fields in the table (pickerCases and LoaderCases)
Any help is greatly appreciated.