Dear Friends,
I want to generate a query from the following type of database
Bill No. Bill Date Customer I.D. Bill Amount 1 01/09/2018 3092 2042 2 01/09/2018 3392 125 3 01/09/2018 CashBill 4458 4 03/09/2018 211 949 5 03/09/2018 932 447 6 03/09/2018 442 412 7 04/09/2018 301 885 8 04/09/2018 130 44 9 05/09/2018 CashBill 1258 10 03/10/2018 33 199 11 03/10/2018 99 482 12 07/10/2018 399 124 13 09/11/2018 76 447
My requirements is Generating Monthly Total of Sales Details
(i.e.)
Month Monthly Sales Cumulative Sales September 2018 10620 10620 October 2018 805 11425 November 2018 447 11872
I can generate a query for Monthly Sales figure with Month & Year, but I don't know how to write a query for Cumulative Total? Is it possible to generate a cumulative total as I shown above in a single query? Or is there any way to generate the result set as shown above?
My requirement is not ended by just with this. After that, if I select any month I need Date-wise Sales Total with Cumulative Total for each Date also.
Can anybody help me please.