All Features

• Different Data Sources
  • OLAP Cube via XMLA protocol
  • CSV files exported from Excel
  • XML from custom web services
• Optimized Grid
  • 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
    Percent	Values in percent

• 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.
• Export
  • CSV
  • HTML
  • Image
• 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.
• 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.
• 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%.
• Embed to Web applications. Java Script API
• Embed to Flex and AIR applications. Flex API
• 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.
• Localization