Compare date range

[spividori]

In the attached example, I need to calculate for each day of the dimension five days back and compare them with five days previous to the first 5.

For example, for the day 30/09 day should add 30,29,28,27,26 / 09 and compare them with the days 25,24,23,22,21 / 09.

In the example there are more clarification.

Regards.

[sunny_talwar · Accepted solution]

May be this:

=RangeSum(Above(Sum(Imp), 0, 5)) - RangeSum(Above(Sum(Imp), 5, 5))