How to SUM the last three months

ashasli

In the line item "last 3 months sum", I'm trying to sum the last three months.

I tried using timesum but wasn't getting the right numbers.

Any help appreciated, thanks!

seymatas1

Hi @ashasli,

Try using MOVINGSUM().

You can also watch this legendary video by Rob.
TIMESUM vs. MOVINGSUM

I hope this helps.

Seyma 🌷🙂

ashasli

Thanks @seymatas1 it worked! MOVINGSUM(last 3 months, -3, -1, SUM)