Explore relations and aggregated results among more than one pair of column fields.
A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field. Pivot tables are the perfect solution when you need to summarize and analyze large amounts of data.
Regardless of where your data is located, in databases such as MySQL or SQL Server, in CSV or Excel file, by loading those data to
Pivot process, you are able to turn them into perfect insights. The results from Pivot can be displayed interactively in which your user can browse through each data segments.
KoolReport's Pivot package is the perfect PHP library to construct excellent data reports and dashboards.
A pivot table helps users answer business questions with minimal effort. Common pivot table uses include:
When users create a pivot table, there are three main components:
Pivotprocess which is capable of grouping data by multi-dimensional rows and columns and providing value calculation.
Pivotwidget to visualize the pivot result which you are able to explore by expanding/collapsing data segments.
PivotMatrixwhich is an interactive php pivot tables where your user's can explore data by drag and drop fields to rows or columns.
PivotExtractprocess helps you to get specific data segment for your own usage, drawing a chart or graph for example.
The details of how to install and how to use Pivot package can be found at our documentation.
The package can be purchased per project under Regular License or Extended License. The Regular License is for project of which users are not charged for. The Extended License is used for commercial project of which users are charged for.
The package is also available in the KoolReport Pro which contains all our packages and allow you to use in unlimited projects.
This makes page reporting so easy. Looking forward to working with the product!
This package is essential for any report! You guys are the best!