Table of Contents

Introduction
What's New In Prism?
Offline (PDF) Version of this Guide
Before You Start
Connecting To Data
Managing Data Sources
Browsing Data
Creating Prism Applications
Creating Reusable Groups and Filters
Creating Reusable Custom Measures and KPIs
Sharing, Distribution and Security
Exporting
Widgets
PrismFAQ

Adding a Pivot Table		Send comments on this topic.
See Also

Pivot tables are one of the most useful Widgets for visualizing data. They allow you to quickly summarize and analyze large amounts of data, independent from the original data layout.

Add a Pivot by dragging it from the Widget Pane or by right-clicking an empty area on the sheet and navigating to New->Pivot.

The Widget Data Editor configuration for a Pivot contains four panels:

Rows Panel: Defines Members that are displayed as rows in the table.
Columns Panel: Defines Members that are displayed as fields (columns) in the table.
Measures Panel: Defines the numeric values to display.
Background Panel: Restricts results to those that intersect with filters defined in this panel.

See Also