The JIDE Pivot Grid is a Java/Swing implementation of the famous PivotTable feature as you can find in Microsoft Office Excel as well as many other analytic and OLAP applications. A pivot table enables you to take what seems to be an indecipherable mass of facts and extract any trends and patterns buried in the data. You can organize and summarize your data, perform comparisons, and extract meaningful information that can be invaluable to you and your organization. It’s a very powerful tool and now you finally can use it in your Java application with several lines of code. JIDE Pivot Grid is built on top of the award winning JIDE Grids which provides a solid foundation for table related features in Java/Swing.

Features

• Support reading data from any TableModel that can be generated from any data sources such as database, XML, file, network stream, you name it.
• Support drag-n-drop to rearrange pivot fields by end users.
• Automatic calculate summary for your data. It supports SUM, MAX, MIN, MEAN, VAR, STDDEV, COUNT by defaults. You can also introduce your own summary using Java code.
• Automatic calculate total and grand total for row fields and column fields.
• Supports group values using ObjectGrouper. For example, you can group all sales data in the first three months of a year to Quarter 1 if you want to analyze sales data quarterly.
• Supports customized cell styles and format for cells in data table, row header and column header table.
• Filtering support
• Sorting support
• Supports calculated field, a new field which is calculated from another field or fields in the original data source. Supports a powerful expression to allow user to define a new field on fly.
• Supports saving pivot layout to xml file and load it back.
• AggregateTable is a special table that can aggregate/merge cells with the same values and add expand button to expand or collapse the rows.