Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default Can I pull 2 different data tables into one pivot table

I have 2 streams of data I need to pull into one pivot table, they can be
mapped together by a customer number

How can I go about pulling the data down then merging them to one pivot table?

Thanks
--
Nelson
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default Can I pull 2 different data tables into one pivot table

You must merge the data into a single consolidated source prior to loading.
You can not make relational links during a load.
--
HTH...

Jim Thomlinson


"Nelson" wrote:

I have 2 streams of data I need to pull into one pivot table, they can be
mapped together by a customer number

How can I go about pulling the data down then merging them to one pivot table?

Thanks
--
Nelson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull data from different worksheets/tab into one Pivot Table MMangen Excel Worksheet Functions 3 August 4th 09 05:36 AM
Pivot tables - edit pivot table and updating master data MikeSA Excel Programming 2 June 4th 09 12:03 PM
Pull Pivot Table Data Dave Excel Discussion (Misc queries) 0 May 23rd 06 03:11 PM
Pull pivot table data Dave Excel Discussion (Misc queries) 1 May 20th 06 01:01 AM
Can a Pivot Table pull data from Multiple WorkSheets ? GSears Excel Programming 1 May 24th 04 02:39 PM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"