Categories | Question details Back To List | ||
GroupBy and aggregate functions When grouping on data in the grid control, is there a way to get a sum, avg, etc. on that data? e.g. PURCHASEDATE ITEM PRICE 01/12/1999 Peppers $9.00 01/12/1999 Pepperoni $10.00 01/15/1999 Grapes $2.00 01/16/1999 Squash $4.00 If I group on the the "purchasedate" field (GroupBy(0);), my grouping header will show as: 01/12/1999 (2) I would like for it to display the sum of the "price" column at that date - $19.00. Answer posted by Support on Aug 13, 2009 01:27 You can check the related article http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Math_operations_in_group.html#grid_mathingrp |