Calculated fields in recordset?
Good morning, not specifically a DA issue but wondered if anyone could help? DA creates my results tables perfectly, 2 columns contain numbers & currency, is there anyway using php to calculate these fields, such as adding sum values to table footer?
I did think to do this in mysql using SUM (sales_price) AS Total but the recordset is dynamic and can change as I filter the records ie;
Staff1 10 £250
Staff2 15 £300
Staff2 5 £100
Staff3 20 £400
Total 50 £1050
If I then filter it to 'staff3' I need it to update as such;
Staff3 20 £400
Total 20 £400
Kind regards
Gary