Perform calculations(sum) after quick find/search
Recently, I am writing an invoice data base to record the sales of different products, I wish to perform a sum calculation after searching of a product to show the total sales($) from all the invoices of it.
for example, I have product A and B in my company, and I use invoice to keep record of how many and how much each product sold. so how can I look for the total sales($) of product A or B sold?
do i need a script? calculation? or anyways to achieve it?
thx for your kindly help