How do I make your system have a pivot table function?

pivot Table/graph by filtering, sorting, and summarizing your data, you can generate summary tables or charts that 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!

Grape City componentone product line componentone Studio(Windows platform) and Wijmo (JavaScript platform) control package, which 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.

650) this.width=650; "style=" Width:auto;height:auto; "src=" http://mmbiz.qpic.cn/mmbiz/ 9eqpq8bxg1xihzezsgyvo5jzvkzfr4ick3wuvu1ikf6mpiazuouzzxjkumdvldacjf6qzicguq5vnp99dd6vtbfiba/640?wx_fmt=png& Wxfrom=5&wx_lazy=1 "alt=" 640?wx_fmt=png&wxfrom=5&wx_lazy=1 "/>

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.

650) this.width=650; "style=" Width:auto;height:auto; "src=" http://mmbiz.qpic.cn/mmbiz/ 9eqpq8bxg1xihzezsgyvo5jzvkzfr4ickkz4tngilfyc9joiatbjjgxcribfxhuhazgedwtgnmlzqkkkrfpyjhcjw/640?wx_fmt=png& Wxfrom=5&wx_lazy=1 "alt=" 640?wx_fmt=png&wxfrom=5&wx_lazy=1 "/>

Information such as chart types can be set through the Chart menu, such as a line chart.

650) this.width=650; "style=" Width:auto;height:auto; "src=" http://mmbiz.qpic.cn/mmbiz/ 9eqpq8bxg1xihzezsgyvo5jzvkzfr4ick5f0mn3edfupwwshpptoluytiojadicfrjykrkfsjyr2of9ekibygvnaw/640?wx_fmt=png& Wxfrom=5&wx_lazy=1 "alt=" 640?wx_fmt=png&wxfrom=5&wx_lazy=1 "/>

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 Learn more, download trial please poke here . .

We also provide tools Wijmo in the JAVESCRIPT environment, please Click here Learn More .

ComponentOne product line, all-purpose development tool package.  

How do I make your system have a pivot table function?