PC Review


Reply
Thread Tools Rate Thread

Can I pull 2 different data tables into one pivot table

 
 
Nelson
Guest
Posts: n/a
 
      21st Aug 2009
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 With Quote
 
 
 
 
Jim Thomlinson
Guest
Posts: n/a
 
      21st Aug 2009
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull data from different worksheets/tab into one Pivot Table MMangen Microsoft Excel Worksheet Functions 3 4th Aug 2009 05:36 AM
Pull Pivot Table Data =?Utf-8?B?RGF2ZQ==?= Microsoft Excel Misc 0 23rd May 2006 03:11 PM
Pull pivot table data =?Utf-8?B?RGF2ZQ==?= Microsoft Excel Misc 1 20th May 2006 01:01 AM
Pivot table data refresh at the pull down =?Utf-8?B?TEtheQ==?= Microsoft Excel Misc 2 13th Oct 2004 10:25 PM
Can a Pivot Table pull data from Multiple WorkSheets ? GSears Microsoft Excel Programming 1 24th May 2004 02:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:38 AM.