PivotTable /Graph by filtering, sorting, and summarizing the data, you can generate summary tables or charts to help you analyze, organize, and present your data to improve productivity and reduce errors.
Excel's pivot table is powerful, so can we embed the same functionality in our own development system?
Of course!
The ComponentOne Studio (Windows platform) and Wijmo (JavaScript platform) control packages of the Grape City ComponentOne product line can help you achieve this functionality.
The following is an example of the ComponentOne Studio for WinForm platform Flexpivot Control, which is described below.
Users drag and Drop fields to row fields, column fields, values, and filter areas. For example, the user drags the "Category" to the column field, "Country" to the row field, "Sales" to the value. What you see in the grid is the PivotTable report, which totals "sales" on a column based on "Country" and "sales" on the row, according to Category. and the "OrderDate" is set to filter only show data for 1995 years. When we set up in the area, the data in the grid is updated at any time.
Switch to the chart and we can see the pivot table, which visually responds to sales in different countries in 1995 with a stacked column chart. The different colors in each bar represent the Category.
Information such as chart types can be set through the Chart menu, such as a line chart.
All of the images you see above are provided by the Flexpivot control.
You can also generate a PivotChart report preview, print, or export to an Excel file, or save it as a Flexpivot file.
Flexpivot, like the rest of the Flex family, is known for its performance and can process millions of rows of data from more than 10 unused data sources in milliseconds. A powerful data engine and a wealth of business intelligence analytics to help you build an aesthetically pleasing interface and more powerful business functions.
Flexpivot Features:
Code-free Analysis for multiple different data sources
Excel-like design panel
Create a dynamic, summarized view by dragging data fields into a list in the UI
Interactive grids, charts, and reports to meet different business needs
Built-in powerful data engine for fast processing of millions of rows of data
Managing large datasets with collapsed row and column groupings is easy
Please login componentone Chinese website to learn more, download trial please poke here .
We also provide tools Wijmo in the JAVESCRIPT environment, please click here for more information.
ComponentOne product line, all-purpose development tool package.
How do I make your system have a pivot table function?