hello,
I want to get the total sales by Month Year in one Table as shown below. the month year shows will varies depending on sales calculation (will take 3 previous month from year /month selection). how can I calculate the total sales by monthyear? is it feasible?
| Day | Month and Year | Net Sales - Selling Price | Total Sales |
| 1 | Feb-2019 | 10.00 | 518 |
| 1 | Mar-2019 | 12.00 | 513 |
| 4 | Feb-2019 | 15.00 | 518 |
| 4 | Mar-2019 | 11.00 | 513 |
| 5 | Feb-2019 | 25.00 | 518 |
| 5 | Mar-2019 | 288.00 | 513 |
| 6 | Feb-2019 | 200.00 | 518 |
| 6 | Mar-2019 | 200.00 | 513 |
| 7 | Jan-2019 | 250.00 | 252 |
| 7 | Feb-2019 | 268.00 | 518 |
| 7 | Mar-2019 | 2.00 | 513 |
