Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table with Multiple Consolidation ranges | Excel Worksheet Functions | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
Pivot Table-Multiple Consolidation Ranges | Excel Discussion (Misc queries) | |||
Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
Multiple Consolidation Ranges | Excel Discussion (Misc queries) |