Combining Multiple Tables in a Single Pivot Table

crookesa

Board Regular
Joined
Apr 11, 2013
Messages
88
I have a table for each month of the year on separate tabs each one named (both table and sheet) corresponding to the respective month
The tables need to be on separate sheets for usability reasons.

I want to create a pivot table which takes all 12 tables as input on one single sheet and allow me to filter based on the date in each table.
The entries on each sheet will have a working week calculated with each working week possibly have entries across 2 months.

I have tried using the pivot Table wizard by adding all 12 named ranges e.g. January, February corresponding to each table, etc...

I can't seem to get the consolidated pivot table report to look like that one I have created on each monthly sheet.

Is this possible or am I fighting a losing battle, I've tried a few tutorials on youtube, etc. but can't get it right.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I'll have a look at it but my first time going into this side of things in Excel... Any tips or resources available for an intro?
 
Upvote 0

Forum statistics

Threads
1,223,054
Messages
6,169,835
Members
452,284
Latest member
TKM623

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