Need to Make Pivot Table from 4 Data Tables

[lmcauthen00]

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.

 

[sandy666]

try Alt+D+P

 

[lmcauthen00]

I've tried that, but it condenses all of my fields and doesn't give me the right outputs for my table

 

[sandy666]

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

 

[lmcauthen00]

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!

 

[sandy666]

there is 6 tabs in green

 

[lmcauthen00]

Huh, well the tabs I need the data for pivot table is Deferred Revenue, Def - Professional Service, Direct Revenue, and Def - Transaction

 

[sandy666]

ok, sheet 1 (yellow tab)
is that what you want?

excel file

 

[SpillerBD]

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.

 

[lmcauthen00]

I can't open the file, too large. Can you please email to me? lmcauthen14@gmail.com