P

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]

page areas 2nd
page breaks
     in VBA pivot tables
page fields
Page fields
     multiple consolidation range pivot tables 2nd
page fields
     multiple consolidation range pivot tables, creating in
page fields (VBA)
    reports, filtering
         in VBA 2nd 3rd 4th 5th
Page Layout option (PivotTable Options dialog)
PageField section (PivotTable Field dialog)
     hiding items options
passwords
     Excel, saving in
pie charts
     pivot charts as 2nd
pivot caches
     creating
     refreshing
pivot charts
     alternatives to
         standard charts 2nd 3rd 4th
         workbooks 2nd
     as pie charts 2nd
     chart types, availability of
     creating 2nd
     defining 2nd
     Drop Category Fields Here area
     Drop Page Fields Here area
     Drop Series Fields Here area
     formatting
    month exclusions for certain data items
         troubleshooting
     pivot tables, creating on same sheet as
    rules
         customization permanancy 2nd
         element size/location limitations
         layouts 2nd 3rd
     worksheets, embedding on 2nd
pivot table referencing formulas, copying
     troubleshooting 2nd
pivot table reports
     as interactive Web pages 2nd 3rd 4th
     changing summary calculations
         blank cells causing counts
     data source changes 2nd
    data sources
         blank cells 2nd
         column headings
         column headings, unique headings
         field formatting
         gaps 2nd
         good design attributes 2nd
         preparation case study 2nd 3rd
         repeating groups as columns
         storing in section headings 2nd
         tabular layouts 2nd
     defining
     division revenue contribution reports 2nd
     formatting 2nd
         AutoFormat Table option (PivotTable Options dialog)
         AutoFormatting 2nd
         case study 2nd
         For Empty Cells Show option (PivotTable Options dialog)
         For Error Values Show option (PivotTable Options dialog)
         Grand Totals for Columns option (PivotTable Options dialog)
         Grand Totals for Rows option (PivotTable Options dialog) 2nd
         Mark Totals with * option (PivotTable Options dialog)
         Merged Labels option (PivotTable Options dialog) 2nd
         multiple sections at once
         Page Layout option (PivotTable Options dialog)
         Preserve Formatting option (PivotTable Options dialog)
         Repeat Item Labels on Each Printed Page option (PivotTable Options dialog) 2nd
         Set Print Titles option (PivotTable Options dialog)
         Subtotal Hidden Page Items option (PivotTable Options dialog)
     limitations of 2nd
    macros
         reasons for using
     pivot caches, creating
     removing subtotals
     revenue by line of business reports case study 2nd 3rd
     seasonality reports 2nd
         line comparisons
         measuring percentages in multiple field
         tracking cell importance 2nd
    Top 10 reports
         producing 2nd 3rd
     year-to-prior year comparisons
     year-to-year comparisons
     YTD numbers, tracking
pivot table toolbar
    customizing
         for custom formatting
     redisplaying 2nd
     Refresh Data icon
pivot tables
     adding columns to
     adding fields to 2nd
     adding rows to
    blank tables
         creating
     column areas
    creating
         case study 2nd 3rd 4th 5th 6th 7th
         file size/memory requirements
         from existing pivot tables
         from existing pivot tables, file size limitations
         from existing pivot tables, pivot cache changes 2nd
         pivot table reporting system creation case study 2nd
         PivotTable Wizard
         PivotTable Wizard, selecting data source location
         PivotTable Wizard, selecting pivot table location
         PivotTable Wizard, specifying data ranges
     data areas 2nd
     defining 2nd
     development of 2nd
    drop areas
         dragging fields to 2nd
     dropping fields in
    external data
         importing without PivotTable Wizard
     external data options 2nd 3rd
     external data sources, building with
         MS Query case study 2nd 3rd 4th 5th
    field list
         redisplaying
    fields
         customizing, field names
         customizing, reasons for
    formatting
         limitations of 2nd 3rd 4th
         pivot table reporting system creation case study 2nd
     grouping fields
         date fields 2nd
         date fields, by months
         date fields, by weeks 2nd
         date fields, two fields in one report 2nd
         numeric fields
         order lead-time report case study 2nd 3rd
         text fields 2nd 3rd
     hard data, converting to
     hiding data 2nd 3rd 4th 5th
     hiding Data Field items
     hiding items without data 2nd 3rd
     hiding Page Field items 2nd
    location
         selecting via PivotTable Wizard
     multiple consolidation range tables 2nd
         case study 2nd 3rd
         Column fields
         creating, defining dataset ranges 2nd
         creating, naming dataset ranges 2nd
         creating, page fields
         Page fields 2nd
         Row fields
         Value fields 2nd
    OLAP pivot tables
         arranging data 2nd
         autoformatting
         autosorting
         displaying top/bottom records
         drilling into data 2nd 3rd 4th 5th 6th 7th
         versus Excel-stored data, calculated fields
         versus Excel-stored data, data handling
         versus Excel-stored data, drilling through data 2nd
     page areas 2nd
    pivot charts
         layouts 2nd
     pivot charts, creating on same sheet as
    pivot table toolbar
         redisplaying 2nd
     rank number fields, adding 2nd
    reappearing deleted data items
         troubleshooting 2nd
     rearranging 2nd
     redefining
    refreshing
         disappearing data, troubleshooting 2nd
    repeated data items
         troubleshooting
    reporting systems, creating
         case study 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
     row areas
     showing data 2nd 3rd 4th
     showing Data Field items
     showing items without data 2nd 3rd
     showing Page Field items 2nd
     sorting
         manual sorts 2nd
         via Advanced Options dialog 2nd
         via Standard toolbar sorting buttons 2nd
     synchronization via macros case study 2nd 3rd 4th 5th
     usage scenarios 2nd 3rd
    VBA pivot tables
         adding fields to
         AutoSort feature
         blank cells 2nd 3rd
         borders
         building
         building, CreatePivotTable method
         building, defining pivot caches 2nd
         building, defining Sum of Revenue fields 2nd
         building, Excel version differences 2nd
         calculated fields 2nd
         calculated items 2nd
         calculation options
         calculation options, BaseField property 2nd
         calculation options, xlPercentDifferenceFrom property 2nd
         calculation options, xlPercentofTotal property
         captions
         changes to/deletions in
         converting to reports
         data averages 2nd
         default number format
         default number format, changing 2nd
         default sort order
         default state annoyances 2nd
         dropping fields to
         Excel 97 case study 2nd
         filtering multiple items in PivotFields 2nd
         filtering recordsets 2nd 3rd
         filtering reports via page fields 2nd 3rd 4th 5th
         Grand Total for rows, suppressing
         grouping data by week 2nd 3rd 4th
         manual sort order
         minimum/maximum data 2nd
         multiple fields 2nd
         Outline view
         Outline view, fixing 2nd
         page breaks
         producing executive overviews 2nd 3rd 4th
         sizing 2nd 3rd 4th
         subtotal rows 2nd 3rd
         subtotal rows, suppressing 2nd
         summarizing date fields via grouping 2nd 3rd 4th 5th 6th
         summary reports, building workbooks
         summary reports, customizing worksheets
         summary reports, fixing Outline view 2nd
         summary reports, producing 2nd 3rd 4th
         summary reports, subtotal rows 2nd
         titles
     when to use 2nd
PivotFields
     multiple items, manually filtering 2nd
PivotTable Classic format (AutoFormat) 2nd 3rd 4th
PivotTable Field dialog
     displaying
     Field Settings command
    Format Cells dialog
         Number tab, applying field numeric formats
     Name text box
    Options button
         accessing field running total options
    Options command
         Show Data As combo box 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
    PageField section
         hiding items options
    Subtotals dialog
         Custom option 2nd
     Summarize By section
         Average function
         Count function
         Count Nums function
         Max function
         Min function
         Product function
         StdDev function
         StdDevP function
         Sum function
         Var function 2nd
         VarP function 2nd
     versions of 2nd
PivotTable Field dialog box
     None under Subtotals command
PivotTable Field List
    Dimension fields
         expanding
PivotTable field name is not valid error message
     troubleshooting
PivotTable Options dialog
     accessing
     Background query option
     Enable drill to details option
     Optimize memory option 2nd
     Refresh every option
     Refresh on open option
     Save data with table layout option 2nd
     Save password option
PivotTable Report command
    pivot tables
         creating
PivotTable Wizard
     activating
     Another PivotTable or PivotChart Report option 2nd
    Choose Data Source dialog
         OLAP Cubes tab
    Create New Data Source dialog
         local OLAP cube connections
    data sources
         range expansion updates
     Layout dialog box 2nd
    Multidimensional Connection dialog
         local OLAP cube connections 2nd
     Multiple Consolidation Ranges option 2nd
     pivot table creation
         selecting data source location
         selecting pivot table location
         specifying data ranges
    pivot table reports
         AutoFormatting
precalculated calculated fields
Preserve Formatting option (PivotTable Options dialog)
Product function
Product page fields
Project Explorer (VBA Editor)
     enabling
properties (VBA)
Properties window (VBA Editor)