Features

FlexPivot provides features for filtering, grouping, sorting, analyzing, visualizing, and reporting on multidimensional data.

The following topics describe these capabilities:

Applying Themes - Themes control the visual appearance of the FlexPivot interface and help maintain a consistent style across reports.

Conditional Formatting - Conditional formatting highlights values based on defined conditions, making trends and exceptions easier to identify.

Creating Reports - Reports organize and summarize data using rows, columns, and value fields.

Data Slicing - Data slicing filters data interactively by selecting specific values, enabling focused analysis of data subsets.

Drilling Down Data - Drill‑down displays the underlying records that contribute to summarized values.

Import and Export - Import and export operations allow FlexPivot definitions or report results to be shared, stored, or analyzed externally.

Filtering - Filtering limits the data included in analysis by restricting fields or values.

Formatting Numeric Data - Numeric formatting defines how values such as currency or percentages appear in results.

Grouping - Grouping organizes fields such as dates or numeric ranges into meaningful categories.

Joining- Joining combines multiple data sources or related tables to support more comprehensive reports.

Multiple Values - Multiple value fields allow reports to display several measures simultaneously.

Shows As - Alternative calculations display values as percentages, differences, or other derived results.

Sorting - Sorting organizes pivot fields and values to improve report readability.

Subtotal Function - Subtotals summarize grouped fields by calculating intermediate results.

Weighted Averages and Sums - Weighted calculations compute averages or sums based on assigned weights.