Index
SYMBOLS
% Difference From option (Show Data As combo box), 45
% of Column option (Show Data As combo box), 46
% Of option (Show Data As combo box), 48
% of Row option (Show Data As combo box), 46
% of Total option (Show Data As combo box), 47
NUMBERS
1992 summary report case study, 2-4
80/20 rule, 88
A
actions, setting in OLAP cubes, 183
adding
fields to pivot tables, 26-27, 205, 256-257
functionality to recorded macros, 190-193
rank number fields to pivot tables, 256-257
scrollbars to spreadsheets, 191
subtotals to fields, 42-43
Advanced Filter command, Unique Records Only option, 2
Advanced Options dialog, 80
AutoShow feature
logic bugs, 90
Top 10 AutoShow settings, 90-91
AutoSort feature
layout changes effects on, 82-83
Top 10 AutoShow ...
Get Pivot Table Data Crunching now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
