Single Pivot Table 4 Multiple Sheets?

[Guest]

I have four sheets showing a performance of four different zones in selling
different brands. All the sheets are of the same format. Is it possible to
have a single Pivot table to summarize them all into one?

 

[Peo Sjoblom]

http://www.contextures.com/xlPivot08.html


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Guest]

Thanx Peo,

It was a good link!

However, there's a problem. The exactly same columns in 2 sheets are:
Branch Product Amount Units

Now only want to consolidate in the format as:
Sheet1 Product-A Product-B
Branch-A Amount Amount
Units Units
Branch-B Amount Amount
Units Units

But the Consolidation ranges result in a format of a pivot table as:

Branch-A Sum of Product Sum of Amount Sum of Units
Branch-B Sum of Product Sum of Amount Sum of Units

Any idea, How 2 "customize" the layout for further clarification of fileds
rather than only having three fields of row, column & value?

Thanx again

 

[dan892]

I stopped using Excel for pivot tables for reason such as this. They just don't handle them well I did find an application called numberGo (you can type that into Google to find it). This lets you import data from multiple data sources, into one pivot table. It's probably exactly what you're looking for. I've been using it for a while and I wouldn't go back. If you have any questions about it, let me know.

Good luck!

Dan

Thanx Peo,

It was a good link!

However, there's a problem. The exactly same columns in 2 sheets are:
Branch Product Amount Units

Now only want to consolidate in the format as:
Sheet1 Product-A Product-B
Branch-A Amount Amount
Units Units
Branch-B Amount Amount
Units Units

But the Consolidation ranges result in a format of a pivot table as:

Branch-A Sum of Product Sum of Amount Sum of Units
Branch-B Sum of Product Sum of Amount Sum of Units

Any idea, How 2 "customize" the layout for further clarification of fileds
rather than only having three fields of row, column & value?

Thanx again

"Peo Sjoblom" wrote:

> http://www.contextures.com/xlPivot08.html
>
>
> --
>
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> (Remove ^^ from email)
>
>
> "FARAZ QURESHI" wrote in message
> news:[email protected]...
> >I have four sheets showing a performance of four different zones in selling
> > different brands. All the sheets are of the same format. Is it possible to
> > have a single Pivot table to summarize them all into one?
>
>
>