Pivot Table Data Crunching for Microsoft Office Excel 2007
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] calculated fields activating calculation rules 2nd creating 2nd 3rd case study 2nd 3rd 4th inserting calculated fields into pivot tables 2nd manually adding to data sources via formulas outside of pivot tables 2nd deleting 2nd formulas, documenting 2nd in VBA 2nd naming calculated fields (OLAP cubes) calculated items 2nd activating calculation rules 2nd creating case study 2nd 3rd 4th deleting 2nd formulas, documenting 2nd hiding in VBA 2nd naming solve order, changing calculation options (VBA pivot tables) BaseField property 2nd xlPercentDifferenceFrom property 2nd xlPercentofTotal property calculations rules calculated fields 2nd calculated items 2nd cell references constants named ranges order of operator precedence 2nd referencing totals worksheet functions Cannot group that selection error messages, troubleshooting 2nd captions in VBA pivot tables case studies building pivot tables with external data sources 2nd 3rd 4th 5th calculated fields creating 2nd 3rd 4th calculated item creation 2nd 3rd 4th data source preparation for pivot table reports 2nd 3rd life after pivot tables 2nd multiple consolidation range picot tables 2nd 3rd order lead-time reports 2nd 3rd pivot table creation 2nd 3rd pivot table reporting systems, creating 2nd external data sources, creating 2nd 3rd importing results queries, creating/formatting pivot tables 2nd queries, defining 2nd report refreshing macro, creating 2nd pivot table reports formatting 2nd pivot table synchronization via macros 2nd 3rd 4th 5th pivot tables creating/formatting 2nd 3rd 4th revenue by line of business reports 2nd 3rd summary reports circa 1992 2nd 3rd 4th VBA pivot tables creating in Excel 97 2nd cell references in calculations cells blank cells in VBA pivot tables 2nd 3rd empty cells in row fields, filling 2nd 3rd 4th formatting 2nd importance, tracking in seasonality reports 2nd changing default number format in VBA pivot tables 2nd summary calculations blank cells causing counts VBA pivot tables Choose Data Source dialog (PivotTable Wizard) OLAP Cubes tab Code window (VBA Editor) column areas Column fields multiple consolidation range pivot tables column headings (data sources) unique headings columns adding to pivot tables repeating groups as selecting as ranges in data sources combining OLAP cubes 2nd command buttons (Forms toolbar) assigning macros to comments in VBA company division revenue contribution reports 2nd comparing lines in seasonality reports configuring macro security settings constants calculation rules converting pivot tables to hard data VBA pivot tables to reports copying pivot table referencing formulas troubleshooting 2nd Count function Count Nums function counts due to blank cells Create New Data Source dialog (PivotTable Wizard) local OLAP cube connections CreatePivotTable method (VBA) pivot tables, building cross-style mouse pointers Custom option (Subtotals dialog) 2nd customizing fields field names reasons for pivot charts permanancy of changes 2nd pivot table toolbar for custom formatting VBA pivot table worksheets |