PivotTable.js – použitie

HTML:

<div id="output" style="margin: 30px;"></div>

JS:

<script type="text/javascript">

	$(function()
	{
        $("#output").pivotUI($("#tab_akvi"),
        {
            rows: ["Produktová skupina"],
            cols: ["Dátum"],
            vals: ["Predaj"],
    		aggregatorName: "Integer Sum",
            hiddenFromDragDrop: [],
            hideTotals: true,
        });
     });
</script>

Formátovanie čísiel:

<script type="text/javascript">
    // This example loads data from the HTML table below.

	$(function()
	{
		var sum = $.pivotUtilities.aggregatorTemplates.sum;
        var numberFormat = $.pivotUtilities.numberFormat;
        var intFormat = numberFormat({digitsAfterDecimal: 0, thousandsSep:" "});
		var heatmap =  $.pivotUtilities.renderers["Heatmap"];

        $("#output2").pivot($("#tab_akvi"),
        {
            rows: ["Produkt popis"],
            cols: ["Mesiac", "Week"],
			aggregator: sum(intFormat)(["Forecast ks"]),
			renderer: heatmap

        });
     });
</script>