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?

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
...
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?

Thanx Peo,

It was a good link!

However, there's a problem. The exactly same columns in 2 sheets a
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
...
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?