Designed as powerful data analysis tools to deliver high-end business intelligence capabilities, the FlexPivot controls can be used for various data blending operations, which are listed below. Once connected to data (Invoices view of C1NWind.mdb file), you can implement all these data blending features in the FlexPivot controls as illustrated in the following subtopics.

Filtering

Learn to filter specific values in a list using value, range and Top N filters.

Grouping

Learn to group data by string, numeric, and date fields and fiscal year.

Sorting

Learn to sort data in flexPivot.

Drill-Down

Learn to drill-down through data in the database in FlexPivot.

Subtotals

Learn to calculate subtotals, weighted average and sums.

Show As

Learn to compare different measures, or show changes in the measured values over a period time.