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] Office Web Components (Microsoft) OLAP (Online Analytical Processing) defining OLAP (Online Analytical Processing) cubes benefits of 2nd calculated fields combining 2nd defining dimension fields local cube connections 2nd local cubes, building measure fields 2nd 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 prebuilt data views server cube connections 2nd setting actions in summary tables viewing online writing back to OLAP (Online Analytical Processing) servers cube connections 2nd defining OLTP (Online Transaction Processing) databases data storage Optimize memory option (PivotTable Options dialog) 2nd Options button (PivotTable Field dialog) accessing field running total options Options command (PivotTable Field dialog) Show Data As combo box 2nd % Difference From option % of Column option % Of option % of Row option 2nd % of Total option Difference From option Index option 2nd Running Total In option order lead-time report case study 2nd 3rd order of operator precedence (calculation rules) 2nd Outline view (VBA pivot tables) fixing 2nd |