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