Combining two data sources in a Pivot table.

E

Erasmus Bowen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot table, two data sources. 3
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Table Counting Text Data 0
Pivot Table - Row Label Combination 0
How to combine two column labels in a pivot table 1
Pivot Tables and Filter Criteria Display 0
Slicers and Calculated Items in Pivot Table 2

Top