sum the revenue by every 3 months?

Ozu

I need to sum the revenue by every 3 months and want this to be automatically updated in the dashboard. For instance, if It's august I need to see the revenue of May + June + July. When august ends need to see the sum of June + July + August and how to do this. Can anyone please help?

Michael Culley

If you change the months to numbers (January is 1, February is 2) I came up with this.

=SUM(INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 1, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 2, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 3, months:months, 0)))

Perhaps there's an easier way to do it but this works.

It basically is getting Today's current month and subtracting 1 (previous month), then subtract 2 (2 months ago), then subtract 3 (3 months ago) and pulling the numbers from the revenue column and adding them.

Hope this helps.

Sameer Karkhanis

@Ozu If you added a new column called "Month" then you will need to replace the "Months" to "Month" in the formula or whatever the name you are using for that column.

Michael Culley

@Ozu you put MONTH())-2 you forgot to put MONTH(TODAY())-2

Michael Culley

If you change the months to numbers (January is 1, February is 2) I came up with this.

=SUM(INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 1, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 2, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY()) - 3, months:months, 0)))

Perhaps there's an easier way to do it but this works.

It basically is getting Today's current month and subtracting 1 (previous month), then subtract 2 (2 months ago), then subtract 3 (3 months ago) and pulling the numbers from the revenue column and adding them.

Hope this helps.

Ozu

Thanks for all the help Michael, let me try. I think it will work.

Ozu

I am getting #UNPARSEABLE error, can you please check what I have entered wrong?

Sameer Karkhanis

@Ozu If you added a new column called "Month" then you will need to replace the "Months" to "Month" in the formula or whatever the name you are using for that column.

Michael Culley

@Ozu you put MONTH())-2 you forgot to put MONTH(TODAY())-2