I have Yearly sales column which has to be calculated based on the date and monthly sales columns. Every month I get a record in a table with the date populated in the Date column and sales for that month in the monthly sales column. Now my task is to calculate
the yearly sales for the last 12 months including that month. I am unable to come up with a logic. if my sales for the last 12 months were flat $100, then the yearly sales for the current month should be populated as $1200.
Hope I made my point clear.
View Complete Post