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
