Need to Make Pivot Table from 4 Data Tables

lmcauthen00

New Member
Joined
Oct 30, 2018
Messages
9
I have 4 tables with the same columns (sales, 4 different revenue accounts) and need to make 1 pivot table with the combined data but haven't had any luck. I have tried using the data model, power pivot, power query... Can anyone help me?? I can obviously combine all tables and make 1 pivot, but I have to keep them separate as they are used for other calculations at the same time.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
so describe detailed what you want to achieve.
best option is post a link (onedrive, googledrive or similar) to the excel file (not a picture) with source and expected result
 
Upvote 0
https://drive.google.com/open?id=1YdnhlHk0yeZ6w8XxdSxzyi7r7L-y1I-v

Try this Sandy. I have 4 tabs in green - everything from "Name" to "Dec-18" should be included as field options for my pivot table. The end result I would like to see Revenue Type, Customer Type, and Customer Name as my rows. I would like the SUM of all dates (Jan, Feb, Mar, etc) as my columns/values. There is probably a better way to do this but this is all I have to work with right now. I appreciate your insight!
 
Upvote 0
Huh, well the tabs I need the data for pivot table is Deferred Revenue, Def - Professional Service, Direct Revenue, and Def - Transaction
 
Upvote 0
https://drive.google.com/open?id=1YdnhlHk0yeZ6w8XxdSxzyi7r7L-y1I-v

Try this Sandy. I have 4 tabs in green - everything from "Name" to "Dec-18" should be included as field options for my pivot table. The end result I would like to see Revenue Type, Customer Type, and Customer Name as my rows. I would like the SUM of all dates (Jan, Feb, Mar, etc) as my columns/values. There is probably a better way to do this but this is all I have to work with right now. I appreciate your insight!
It looks like you only need to use the Append feature on your existing Queries in Get&Transform. Should go easy as long as your field headers for each table/query are the same.
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

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