Optimized for huge data sets, smooth browsing and scrolling long reports. You can easily work with 10s millions of facts. Any reasonable data-set which your browser and Flash Player allow to load can be used. Access to any piece of data will take few seconds!
Easy-to-use UI (MS Excel-2007 like)
Advanced manipulation with data: drill-down, sub-totaling, aggregating, filtering, sorting.
Predefined Reports
You can create a predefined report via configuration; define columns, rows, values, and filters to get exact data you need immediately after the Pivot Table is opened.
Rearrange Fields on UI
You can easily rearrange fields and configure any report on UI using "Field List" panel with drag-and-drop.
Drill-Down
Drilling down from the summary data to details.
You can drill-down data both on rows and on columns.
Expand/Collapse Totals
If you have several dimensions on rows or columns at a time, you can expand/collapse levels of data on the report.
You can expand/collapse data both on rows and on columns.
Aggregations
In Pivot Table reports you can use summary functions in value fields. To calculate the value fields, the following summary functions are available for CSV data source:
Function
Summarizes
Sum
The sum of the values. This is the default function for numeric data.
Count
The number of data values
Average
The average of the values
Max
The largest value
Min
The smallest value
Product
The product of the values
Report Filter
Powerful slicer for advanced filtering. It gives an ability to filter the entire report based on the selected item in the report filter.
Convenient way to summarize and quickly focus on a subset of data without modifying your series and category information. For example, you can view sales for all years, and then focus on specific years by selecting one year at a time.
Filter Data
Filters are additive ('AND' filters), each additional filter is based on the current filter and further reduces the subset of data. Filtered data displays only the subset of data that meet the criteria that you specify and hides data that you do not want displayed.
You can filter data both on rows and on columns in the Pivot Table report.
The filter can be either predefined in configuration or applied by user on the UI.
You do not need to reapply the filter. Filters are automatically reapplied every time the Pivot Table is refreshed or updated.
Sorting
You can sort data by sorting field members as text (A to Z or Z to A) or as numbers (smallest to largest or largest to smallest).
Sorting can be applied to several fields at a time.
You can apply sorting for both rows and columns.
Pivot Charts
Charts is the alternative to table way of the data visualization. Pivot Charts are much more. They also are interactive.
Drilling down from the summary data to details on charts.
Different chart types, such as:
bar,
line, pie.
Convenient tooltips and legend.
You can easily switches between charts and table views.
Tools
Full Screen tool is used to enable full screen mode. It takes the Pivot Table report out of the frame of the browser and fills the entire computer screen. Note: to use this feature, flash player should be allowed to use full-screen mode. More details in Adobe documentation.
Print Grid/Charts. It is easy to print a table report or a charts report. If the table report is large to be printed on one paper, it will be automatically divided into sheets for printing. The charts report is printed as single page.
Zoom tool is used to scale the grid and a Pivot Table report on it. Zoom tool is the editable drop down list. To scale grid you can choose one of the predefined values or enter your own. The default scale value is 100%.
Configurable UI
You can easily configure UI, define which UI elements are needed and which ones should be turned off.
XML/FlashVars Configuration. Pivot Table component can be configured via XML or FlashVars. Configuration defines the data source, report configuration: columns, rows, values, predefined filters (filters only in XML configuration); enabling/disabling of UI elements, CSS. To get more information about configuration please read Pivot Table Component Configuration via XML or Pivot Table Component Configuration via FlashVars.
CSS. Skins and visual appearance can be controlled with easy-to-edit CSS and images. To get more information on Pivot Table CSS please read CSS for Pivot Table Skins and Visual Appearance.