Using the Analyzer Introduction to the Analyzer Introduction Accessing the Analyzer Orientation to the Analyzer and Mini Analyzer Displaying a Pivot Table Exiting the Analyzer or Mini Analyzer Location of Pivot Table Definitions Accessing the BI Samples Creating Pivot Tables Introduction to the Autosave Feature Selecting a Subject Area Getting Familiar with a Subject Area Creating a Pivot Table Specifying the Rows in a Pivot Table Specifying the Columns in a Pivot Table Displaying Measures in a Pivot Table Displaying Properties in a Pivot Table Transposing a Pivot Table Changing the Order of Items Copying and Pasting Items Adding a Summary Row or Column Applying 80/20 Suppression Clearing the Autosave State of a Pivot Table Saving a Pivot Table Filtering Pivot Tables About Filters Dragging and Dropping Filter Items Creating and Using a Drop-Down Menu Adding Advanced Filters Filtering the Base Records by Measure Value Defining Named Filters Redefining a Named Filter Deleting a Named Filter Using Named Filters Disabling or Removing Filters How Business Intelligence Combines Filters Finding the Key for a Member Defining Calculated Elements Overview Defining a Calculated Measure Defining a Calculated Member That Is Not a Measure Redefining a Calculated Member Deleting a Calculated Member Defining and Using Pivot Variables Overview Defining a Pivot Variable Defining and Using an Expression Pivot Variable Literal Pivot Variables Redefining a Pivot Variable Deleting a Pivot Variable Customizing Pivot Tables Specifying Pivot Options Customizing Pivot Table Items Displaying a Constant Row or Column Specifying a Spacer Row or Column Displaying an Different Set for Rows or Columns Specifying New Captions Specifying a Format String Specifying Cell and Header Styles Sorting and Filtering Members Specifying Alternative Aggregation Methods for a Measure Customizing Double-Click Drilldown Applying Conditional Formatting Specifying the Print Settings Specifying the MDX Query Manually Working with Pivot Tables Opening a Saved Pivot Table Disabling and Enabling Auto-Execution Canceling a Running Query Exporting Data to Microsoft Excel or CSV file Printing a Pivot Table Sending Email Displaying the Pivot Table as a Chart Deleting a Pivot Table Performing Ad Hoc Analysis Displaying a Detail Listing Drilldown via Double-Click Performing Arbitrary Drilldown Introduction to the Pivot Analysis Window Configuring InterSystems IRIS for PDF Output Using the Built-in PDF Rendering Engine Using Other Rendering Engines