GROUPING IN PIVOT - MULTIPLE CONSOLIDATION RANGES
 

I have data on 2 sheets. The basic structure of both is as follows:

Zone Branch Client Outstanding

Upon creating a Pivot based on Multiple Consolidation Ranges so as to
include the data from both the sheets I need to have Zone & Branch (both) in
the Row Labels while Outstanding in the Column Label so as to have the totals
be computed.

However, the result is coming as with the Zones only being shown in Row
Labels while all the three others on the Column Labels with 0 appearing in
the Blanch & Client and Outstanding totaling on the Zone level.

Any suggestion and guidance.

Thanx in advance.

--
Best Regards,

Faraz

GROUPING IN PIVOT - MULTIPLE CONSOLIDATION RANGES
 

Excel 2007 PivotTable
Multiple Consolidation Ranges
Multiple Row Fields
http://www.mediafire.com/file/iwhytmmmtwk/03_07_09.xlsm

GROUPING IN PIVOT - MULTIPLE CONSOLIDATION RANGES
 

Thanx a lot pal. But unfortunately, the fle is found to be corrupt. Any other
help or reference?
--

Best Regards,

Faraz


"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Multiple Consolidation Ranges
Multiple Row Fields
http://www.mediafire.com/file/iwhytmmmtwk/03_07_09.xlsm