About Tables and Pivots

In Oracle Analytics, you can create table and pivot visualizations to display your data in an organized grid format. You can use them to summarize your data or show it in detail.

A table displays data in rows and columns in a tabular format. A pivot is similar to a table but summarizes and aggregates groups of data values in columns and rows. You can swap the columns and rows in pivots to easily see different summaries of the same data.

For example, you might use a table to show the profit for each product based on customer segment.

Description of the illustration table_example.png

You might use a pivot to show the same data and add a time column to break the profit down by month. The pivot provides a clearer summary of each data element with aggregated totals.

Description of the illustration pivot_example.png

You can customize the look and feel of a table or pivot by configuring the visualization properties. The properties available for these visualization types include options to:

• Configure the font for different cells such as headers, data, and totals
• Configure the header names and totals labels
• Turn available data actions on or off for consumers
• Show or hide grand totals and subtotals
• Configure the number format for measure values

Other useful options when you’re working with tables and pivots include:

• Identify Content with Tooltips
• Highlight Important Data Events with Conditional Formatting
• Hide Columns in Visualizations
• Format Numeric Values of Visualizations
• Set Scale Options for Numbers and Currency Values
• Export Workbook Content in Various Formats