Your system can also have a "pivot table" Function!

Source: Internet
Author: User

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.

Your system can also have a "pivot table" Function!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.