Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
wiki:pivotexample [2014/02/17 15:30] tony |
wiki:pivotexample [2014/02/17 15:33] tony |
||
---|---|---|---|
Line 126: | Line 126: | ||
aggregator : 'sum', | aggregator : 'sum', | ||
width:50, | width:50, | ||
- | label:'Sum Price' | + | label:'Sum' |
}, { | }, { | ||
member : 'Quantity', | member : 'Quantity', | ||
aggregator : 'sum', | aggregator : 'sum', | ||
width:50, | width:50, | ||
- | label:'Sum Qty' | + | label:'Qty' |
} | } | ||
] | ] | ||
Line 142: | Line 142: | ||
The final code with jqGrid setting is: | The final code with jqGrid setting is: | ||
- | <code> | + | <code javascript> |
<script type="text/javascript"> | <script type="text/javascript"> | ||
jQuery(document).ready(function(){ | jQuery(document).ready(function(){ | ||
Line 158: | Line 158: | ||
], | ], | ||
aggregates : [ | aggregates : [ | ||
- | {member : 'Price', aggregator : 'sum', width:50, label:'Sum Price'}, | + | {member : 'Price', aggregator : 'sum', width:50, label:'Sum'}, |
- | {member : 'Quantity', aggregator : 'sum', width:50, label:'Sum Qty'} | + | {member : 'Quantity', aggregator : 'sum', width:50, label:'Qty'} |
], | ], | ||
rowTotals: true | rowTotals: true | ||
Line 170: | Line 170: | ||
rowNum : 10, | rowNum : 10, | ||
pager: "#pager", | pager: "#pager", | ||
- | caption: "Pivot Grid" | + | caption: "Amounts and quantity by category and product" |
}); | }); | ||
}); | }); | ||
Line 183: | Line 183: | ||
</html> | </html> | ||
</code> | </code> | ||
+ | |||
+ | The final result can look like this | ||
+ | |||
+ | {{:wiki:amtbycatprod.png|}} | ||