Hi Everybody,
I have a problem with Pivot Table Totals, as showed here:
I know that it could be dependent on Aggr function, but i have tried with no result.
My measure is composed by two dates put on alternate states, for example if user clicks 202201 on the first date and 202205 on the second one, he/she will get results from january to may 2022 for that specific measure, aggregated by the dimension in pivot table, in this way:
if(ValueList('CY','PY') = 'CY',
Sum ({<YearMonthOrder={">=$(=Only( {DataStart} YearMonthOrder))<=$(=Only( {DataEnd} YearMonthOrder))"}>} num_oda_line_num_CY),
Sum ({<YearMonthOrder={">=$(=Only( {DataStart} date(addmonths(YearMonthOrder,-12),'YYYYMM')))<=$(=Only( {DataEnd} date(addmonths(YearMonthOrder,-12),'YYYYMM')))"}>} num_oda_line_num_CY))
Could you tell me how to edit this formula to get proper totals?
Thanks,
Damiano