Problem with YTD Average Cumulative calculation

[francy8326]

Hi all,

I calculated a YTD average cumulative value grouped by month_year that it is represented as the last day of the month.

(ex. 29/02/2020).

The problem is that when I filter a date month, for example 29/02/2020, I see only the value relative the date selected,  while I would like to see also the average cumulative value to January 2020.

The formula I used is:

(RangeSum(Above(sum({< tipo_misura={'Cessazioni'},date_month={"<$(=Addmonths(max(date_month),+1))"},Year={"$(=max(Year(date_month)))"},date_month=>} valore_misura), 0, RowNo()))
/Max(Num(Month(date_month))))*12

Can anyone help me?

Thanks a lot

Francesca