Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Justin on Aug 12, 2009 14:57
open dhtmlx forum
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