Summarizing Multiple Pivot Charts

Joined
Aug 12, 2022
Messages
1
Office Version
  1. 365
Platform
  1. 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.


fruit.GIF
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top