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.