Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Erasmus Bowen
 
Posts: n/a
Default Combining two data sources in a Pivot table.

Hi,
I have a large CSV data file that I am using as an "external data source"
for a Pivot table in an (autoupdate) template.
That works fine. It's the sales file created automatically by an
application. So it's "sales.csv" and my template with the Pivot table is
"sales.xlt".

But I also have costs, so I have another file where costs are recorded
manually. The data is in "Costs.xls" and I will have another Pivot table
where I analyse the costs : "Costs.xlt"

Now I want to offset Costs against Sales, so I am looking for some way to
get a new pivot table to read both the Sales.CSV and the Costs.XLS data and
combine the results.

Anyone here know how to do that ?
Or, can anyone point me to a site where that is explained.

TIA


Erasmus






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
Pivot Table Data Field Query Pepikins Excel Worksheet Functions 1 June 14th 05 11:58 PM
Combining Pivot Tables - Summarising data from 100,000 rows Alan Excel Discussion (Misc queries) 1 May 18th 05 11:09 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 03:31 PM
pivot table YingRui Oliviero Excel Discussion (Misc queries) 1 April 12th 05 01:57 PM
Pivot table of data in more than one worksheet Rehan Excel Discussion (Misc queries) 1 March 24th 05 10:32 AM


All times are GMT +1. The time now is 06:03 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"