Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
wiki:pivotdescription [2014/02/10 15:32] tony |
wiki:pivotdescription [2017/12/12 17:23] (current) admin |
||
---|---|---|---|
Line 5: | Line 5: | ||
Simple we can say that pivot table is a program tool that allows you to reorganize and summarize \\ | Simple we can say that pivot table is a program tool that allows you to reorganize and summarize \\ | ||
selected columns and rows of data in a spreadsheet or database table to obtain a desired report. \\ | selected columns and rows of data in a spreadsheet or database table to obtain a desired report. \\ | ||
- | A pivot table doesn't actually change the spreadsheet or database itself. In database lingo, to \\ | + | A pivot table doesn't actually change the spreadsheet or database itself. In database lingo, to \\ |
pivot is to turn the data to view it from different perspectives. | pivot is to turn the data to view it from different perspectives. | ||
Line 34: | Line 34: | ||
jqPivotGrid inherits the jqGrid, so you can use most of the features you are already \\ | jqPivotGrid inherits the jqGrid, so you can use most of the features you are already \\ | ||
familiar with: column resizing, formatter, cell renderers, row/cell events etc. \\ | familiar with: column resizing, formatter, cell renderers, row/cell events etc. \\ | ||
- | The jqPivotGrid can be used when you want to get summation and pivot features that aren’t \\ | + | The jqPivotGrid can be used when you want to get summation and pivot features that are not \\ |
provided in the jqGrid. | provided in the jqGrid. | ||
Line 70: | Line 70: | ||
}] | }] | ||
</code> | </code> | ||
+ | |||
+ | As you have probably noticed in the above example, you could aggregate multiple data \\ | ||
+ | fields, say "Price" and "Quantity". You can easily achieve this by configuring all \\ | ||
+ | required aggregations. | ||
+ | |||
+ | {{:wiki:amtbycatprod.png|}} | ||
+ | |||
+ | Showing the grand totals for rows and/or columns is pretty easy to configure \\ | ||
+ | ("rowTotals: true" or "colTotals: true"). The group totals are also available \\ | ||
+ | via rowTotals or colTotals configs. | ||
+ | |||
+ | |||
+ | The pivot grid uses JSON data as data source. In the future we will extend it so \\ | ||
+ | that we can read any data source. \\ | ||
+ | |||
+ | ===== Future ===== | ||
+ | |||
+ | Since jqPivotGrid is a open source product, it will constantly be improved with new features. \\ | ||
+ | Feel free to make this happen. |