Pivot Table & Charts Component

Welcome to Pivot Table & Charts Component — rich internet application designed to view, analyze and manage multidimensional data online. It has 2 main advantages from opposite types of applications:

• usability and speed of desktop application,
• mobility and scalability of web-based application.

Flexmonster Pivot Table can use different data sources and can be embedded in various ways:

Database	→	CSV	→	Pivot Table & Charts	HTML Page
OLAP cube		XMLA			Flex Application
Web-app		XML			Desktop AIR Application

This guide will provide you with quick introduction to Pivot Table & Charts Component, information about its features, and its ways of usage. Pivot Table enables you to analyze numerical data. With Pivot Table, you can look at the same information in different ways with just a few mouse clicks.

Pivot Table and Charts

1. Fields List
2. Pivot Grid or Pivot Chart

1. Fields to choose from
   • Dimensions/Folder tree in OLAP
   • Dimensions in CSV
2. Values to choose from
3. Rows Fields
4. Columns Fields
5. Report Filter
6. Update Report Button
7. Cancel Button

CSV version

OLAP version

Operations

• Add Field Show process
  For adding field to columns, rows, or report filter: simply drag measure line to destination box (border becomes bold) and click Update. Measure that are represented in report, are bold.
• Remove Field Show process
  For removing filed from columns, rows, or report filter: drag field line outside, click Update.
• Add (Remove) Aggregation Show process
  For adding aggregation click it — it becomes checked (unchecked) and bold (normal). The ∑ icon on right — is drop-down for aggregation type. Default is Sum, you may select different. Click Update. To remove — simply uncheck aggregation.
• Change Fields Sequences Show process
  For swapping preferred Fields use drag-and-drop: move selected one up or down and click Update.