Pivot Table from Multiple Ranges

F

Fabio

When creating the Pivot Table from Multiple Ranges, I
always get the same 4 field result as Row, Column, Page,
despite that I have from the origins at least 10 names for
the columns on those ranges.
If I do it from one source only I get those 10 names to
make the design.
What I am doing wrong?
 
M

mohitmahajan

If you select 5 different coloumns from the sheet then excel does no
let you make the table. For this the best thing to do is to take th
data for pivot in a separate sheet.

R u trying to select data from more than one sheet
 
M

mohitmahajan

If you select 5 different coloumns from the sheet then excel does no
let you make the table. For this the best thing to do is to take th
data for pivot in a separate sheet.

R u trying to select data from more than one sheet
 
D

Debra Dalgleish

You can create a PivotTable from multiple consolidation ranges, but you
won't get the same pivot table layout that you would from a single range.

If Client Name is the first column in your data source, the row heading
should show the names. The column area will show each of the remaining
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 PivotTable would contain some meaningless data, such as Sum of
Order# or columns full of zeros for database columns that 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. Or,
after you've created the Pivot Table, hide the column and row items that
you don't need.

If possible, store the data in a database, such as Access, and use that
as the source for the PivotTable.
 
F

Fabio

Yes, I have the data from 4 different sheets.
I'll try less columns to see what happend. Thanks.
 
Top