Import data to pivottable

[Guest]

Hi
Is it possible to create a pivot with reference to several data from diffent
sheets in the same excel file. I am trying to manage data on money
transactions. These transactions are different in their nature (grouped into
the different types) and I would prefer if they were in seperate sheets.

Next problem...

In these sheets I want to manage transaction from an account to an other
account, therefore I got 2 colloms with the name "account name". This curses
some problems because I want the "Row" of the pivottable to be "Account
name". I want the pivottable to give my data on the transfer from and to the
diffent account. How can I solve this?

Best Regards

Michael

 

[Rizitsu]

You can NOT use multiple sheets when working with Pivot tables;

I assume you are using different sets of data, one for account 1 an
one for account 2, this would result in two seperate pivotables
(sheet1, sheet2 and so on)

You can NOT use two seperate sheets with the creation of a pivot table
as when you change sheets it automatically renames your data source.

As a word of advice, if you create a primary set of data for both you
accounts and then when you want to create multiple tables using th
same set of data, simply create a pivot table using an existing table
you can easily locate the name of the table by right clicking an
viewing the table properties (table settings).

This reduces the overall file size of your spreadsheet

 

[Dave Peterson]

#1. Debra Dalgleish posted this:

http://groups.google.com/[email protected]

You could create a Pivot Table from multiple consolidation ranges:

1. Choose Data>PivotTable and PivotChart Report
2. Select Multiple consolidation ranges, click Next
3. Select one of the page options, click Next
4. Select each range, and click Add, click Next
5. Select a location for the PivotTable, click Finish

However, you won't get the same pivot table layout that you'd get from a
single range.

For example, if customer is the first column in your data source, the
row heading should show the customer names. If remaining columns are
Units Sold, Product#, Unit Price and Total, the column area will show
each of those headings. You can change the function that's being used by
the data value, but it will use the same function on all these columns.

The Pivot Table would contain some meaningless data, such as sum of
Product# or columns full of zeros if the database columns contain text.
To avoid this, you can rearrange your database columns, and then use
data ranges that only include the columns that you want to total.

If possible, create your PivotTable from the original data source, or
store it in an Access database table.

#2. Rename the fields???
If you just drag those fields to the row field, don't you get:
Account Name and Account Name2? If you let your cursor linger over
those buttons, you'll see more/all of the name that xl will use.