Need Help with Formula for Rolling Metrics
I am working on a 6 months rolling metrics calculation for a point system.
A simple data involved will be as follows:
1) Date column
2) Points column (0-10)
3) Name column
I need to calculate a 6 months rolling sum of points, for each person.
I couldn't figure out how to calculate the sum of points for each person in 6 months rolling?
(When in the month of August, it will be a sum from March - August, when in the month of September, it will be a sum from April - September).
Anybody can advice on this?