Data Analysis and Reporting with Intelligence Clients

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

Index

Symbols

% Increase function, *

% of Category function, *

% of Column function, *

% of Grand function, *, *

% of Row function, *

Numerics

2-D bar charts, *

3-D bar charts, *

3-D View, *

A

Add Computed Item command, *, *, *, *

Add Cume command, *

Add Date Group command, *

Add Grouping Column command, *

Add Selected Items command, *

Add Totals command, *

adding computed items, *, *, *, *

adding cumulative totals, *

adding date groups, *

adding grouping columns, *

adding lines to labels, *

adding other report elements, *

adding report groups, *

adding totals and subtotals, *

applying data functions to tables, *

area charts, *

ascending sorts, *, *, *

Average function, *, *, *, *

axes, *

axis grid lines, showing, *

B

bar, *

bar charts

2-D, *

3-D, *

stacked, *

three-dimensional, *

two-dimensional, *

best fit, charts, *

Break Total command, *

break total data functions, *

break totals, *

C

changing chart color schemes and fill patterns, *

changing chart data labels, *

changing chart legends, *

changing color of chart elements, lines, and text, *

changing column names, *

changing label nesting levels, *

changing the view of a chart, *

chart angle and elevation, changing, *

chart elements, working with, *

chart format, determining what to use, *

chart formats and types, *

Chart menu commands, *

chart properties, changing, *

Chart section

applying sorts in, *

computed items, *

data functions, *

diagram, *

Outliner, *

Chart This Pivot command, *

charting basics, *

charts

adding computed items, *

adding lines to labels, *

area, *

building, *

combination, *

creating, *

creating from pivot tables, *

inserting text, *

line charts, *

multidimensional, *

Outliner, *

pie charts, *

pivoting, *

ribbon charts, *

stacked bar, *

terminology, *

three-dimensional, *

three-dimensional bar, *

two-dimensional, *

two-dimensional bar, *

zooming, *

color, changing in charts, *

Column commands

Add Grouping, *

Hide, *, *, *

Modify, *

Unhide, *, *, *

Column Name function, *

column names

changing, *

hiding, *

column totals, *

columns, *, *

combination charts, *

commands

Chart menu, *

Pivot menu, *

Report menu, *

Table menu, *

Tables menu, *

comparing related values, *

components, report, *

computed fields, *, *

computed items

adding, *, *, *

Chart section, *

Report section, *

Table section, *

concatenating report element syntax, *

converting detail reports, *, *

Count function, *, *, *, *

creating

charts, *

custom reports, *

pivot tables, *

pivot tables from charts, *

smart reports, *

tables, *

cumulative limits, *

cumulative totals, adding, *

custom functions, *

custom totals, inserting, *

customizing chart patterns, colors, and labels, *

customizing chart properties and labels, *

D

data calculations, in pivot tables, *

Data Function command, *, *, *

data function definitions, *

data functions

in charts, *

in custom reports, *

in pivot tables, *

data, pivoting, *

Date & Time field, *

Date & Time Now field, *

Date field, *

Date Group command, Add, *

Date Now field, *

dates, breakout columns, *

descending sorts, *

design guides, *

Design Guides command, *

Detail reports, converting, *

display differences, *

displaying axis grid lines, *

displaying rulers, *

Drill Anywhere command, *

Drill Down command, *

Drill Up command, *

drilling into charts, *

Drillup command, *

duplicate values, suppressing, *

E

elements

selecting pivot, *

working with chart, *

Expression line, *

expression syntax, *

F

facts, *

features, sort line, *

fields, *

File Name field, *

focus on items, *, *

Focus On Items command, *, *, *

font styles, changing, *

fonts, changing, *

footers

report, *

formatting report items, *

functions

in sorts, *

weighted, *

G

Grand Total command, *

grand total data functions, *

grand totals, inserting, *

graphic elements, *

Grid command, *

grid lines, *

grids, *

group fact syntax, *

group headers, report, *

Group Items command, *, *

group label syntax, *

grouping columns, *

guides, design, *

H

headers

report, *

report group, *

Headers and Footers command, *

Hide Column command, *, *, *

hide items, *, *

Hide Items command, *, *, *

hiding and focusing on charted data, *

hiding and focusing on reported data, *

hiding column names, *

hiding column totals, *

horizontal lines, *

I

Increase function, *

Insert Field command, *

Insert Graphic command, *

Insert Predefined Field command, *

Insert Table command, *

inserting

additional tables in a custom report, *

limit values, *

page breaks, *

page headers and footers, *

report headers and footers, *

text, *

text in charts, *

items, sort, *

K

Keep Together command, *

Keep With Next command, *

L

label reference, in sorts, *

labels, nested, *

Las Saved field, *

Last Printed field, *

layout aids, *

legend, *

legends, positioning and resizing, *

Limit command, *

limit values, in reports, *

limiting data in a table, *

limits

cumulative, *

tables, *

limits, cumulative, *

line charts, *

lines, *

Locked command, *

M

manipulating chart data, *

manipulating table data, *

margins, in Report section, *

Maximum function, *, *, *, *

menu commands

Chart, *

Pivot, *

Report, *

Table, *

Minimum function, *, *, *, *

Modify Column command, *

Modify command, *

Modify Computed Item command, *

modifying pivot tables, *

moving pivot table elements, *

multidimensional charts, *

multiple data sources, in reports, *

N

nested labels, *

Non-Null Average function, *, *, *

Non-Null Count function, *, *, *

Null Count function, *, *, *

number formats, changing, *

Number of Pages field, *

O

object names, *

Outliner

Chart section, *

Pivot section, *

Table section, *

Outliner pane usage, *

ovals, *

P

page breaks, inserting, *

Page Margins command, *

Page Number field, *

Page X of Y field, *

Path Name field, *

Picture command, *

pictures, *

pie charts

rotating, *

pie slices, positioning, *

pivot elements, selecting, *

Pivot menu commands , *

Pivot Outliner, *

Pivot section, diagram, *

pivot tables

calculating totals and subtotals, *

charting, *

how to use, *

modifying, *

selecting elements, *

subtotals, *, *

working with pivot items, *

pivoting data, *

planes, *

plot area, *

positioning pie slices, *

Properties command, *

Q

Query Limit field, *

Query SQL field, *

R

rectangles, *

reference items, in sorts, *

Refresh Data command, *

Remove command, *

Remove Selected Items command, *, *, *

removing columns, *

reordering columns, *

report components, *

report element syntax, concatenating, *

report expression syntax , *

report group headers, *

report headers and footers, *

Report menu commands, *

Report Name field, *

report pages, *

Report section

computed fields, *

computed items, *

creating smart reports, *

data functions, *

diagram, *

elements, *

Expression syntax, *

fields , *

formatting items, *

formatting techniques, *

graphic elements , *

limit values, *

toolbar, *

using multiple data sources, *

Report Setup command, *

reports

adding computed items, *

data functions, *

inserting page breaks, *

smart, *

Restore Name command, *, *

Result Limit field, *

ribbon charts, *

rotating and elevating charts, *

rotating pie charts, *

round rectangles, *

Rulers command, *

S

Section Boundaries command, *

selecting chart elements, *

selecting columns, *

selecting pivot table elements, *

setting up

page columns, *

reports, *

Show All Items command, *, *, *

Show Hidden Items command, *, *, *

showing column names, *

showing column totals, *

showing pie percentages, *

showing positive and negative values, *

slice, *

smart reports, *

Sort Ascending command, *, *, *

Sort command, *, *

Sort Descending command, *

sort items, *

sort line features, *

sorting

chart items, *

charts, *

pivot tables, *

report items, *

reports, *

tables, *

specifying

page margins, *

page size, *

stacked bar charts, *

staging data in tables, *

subtotals, *

Sum function, *, *, *, *

suppressing duplicate values, *

surface values, in data functions, *

syntax

concatenating, *

expression, *

syntax, concatenating, *

T

table column formatting options, *

table dimension syntax, *

table fact syntax, *

Table menu commands, *

Table Outliner, *

Table section

computed items, *

data functions, *

diagram, *

tables

adding computed items, *

limits, *

modifying pivot, *

pivot, *, *, *, *

working with, *

tables as a data staging area, *

text in charts, inserting, *

text labels, *

text, wrapping, *

three-dimensional bar charts, *

Time field, *

Time Now field, *

toolbar, in the Report section, *

Total commands, *

totals

break, *

calculating pivot totals, *

cumulative, *, *

inserting break totals, *

inserting column totals, *

inserting in Tables section

break, *

custom, *

grand, *

surface, *

surface, *

two-dimensional bar charts, *

U

Ungroup Items command, *, *

Unhide Column command, *, *, *

Use Surface Values command, *

V

value reference, in sorts, *

values, *, *, *

vertical lines, *

Visible command, *

W

weighted functions, *

weighted values example, *

wrapping text, *

X

X-Categories, *

Y

Y-Facts, *

Z

Z-Categories, *

zooming charts, *