ExcelPowerUserWannabe
New Member
- Joined
- Aug 12, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I work in a sorting facility and we sort a bunch of fruit and must report on our productivity each week. the numbers represent tons, which some weeks we go through a lot and some we do not. It all depends on how many we receive, and how many people we have working on it. But that aside, I've shown a few pivot tables that summarize productivity. There are about 5 more that follow this same format for different fruits. The pivot tables are nice as I can scan through each one and see how many apples in week 8/6 - 8/12 were sorted, pears, oranges, etc. But looking through all the pivot tables for the week I need to report on (and some weeks we do not receive any of that particular fruit) is not easy when I have to to through 8 of them and show my boss. As you can see, the pivot tables do not align if nothing was done that week. Is there a way to take all 8 pivot tables and combine them to one or something better than having all these pivot tables to look at when reporting to my boss? Sometimes he wants to look at this and complains that he has to look up/down/sideways. Is there some better way to summarize/roll-up this information? think about there are a total of 8 of these that I have to go through (or he does) each week. I apologize for this chart being incomplete, but each category in each pivot table is the same.
Reviewed/Screened/Selected for each fruit.
Reviewed/Screened/Selected for each fruit.