Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 211
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table with Multiple Consolidation ranges Saraladevi Excel Worksheet Functions 0 September 9th 08 10:05 AM
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges [email protected] Excel Worksheet Functions 0 January 18th 07 11:24 AM
Pivot Table-Multiple Consolidation Ranges Rach Excel Discussion (Misc queries) 3 January 12th 07 01:46 AM
Multiple Consolidation Ranges in pivot tables Steve S Excel Worksheet Functions 1 October 18th 06 10:30 PM
Multiple Consolidation Ranges nc Excel Discussion (Misc queries) 2 April 26th 05 10:24 AM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"