Period on period calculations donot show in Total field

I have created a MonthOnMonth%Difference calculated field:
MonthOnMonth%Difference = periodOverPeriodPercentDifference(distinct_count({}),{<date_column>}, MONTH ,1)

In a pivot table, I have added a category in row section, date month field in column and count and periodonperiodpercentdifference in value section.

The problem is that, total section for MonthOnMonth%Differenceis shown as blank:
image

Also, when I filter on last 2 months, the MonthOnMonth%Difference is null for my previous month

Can anyone help?

Thanks in advance,
Ajinkya

For periodOverPeriodPercentDifference you need to have both months to compare. So for May 2023 you would need April 2023 in your table.

In regards to totals, I think that would need to be a feature request. I can mark it as one.

I have added filter stating last 2 months only
In that case, the period on period data for pervious month is not visible

Note: I have data for last 10 months so it is not a data related issue.
It has to do something with the default PRE_FILTER, PRE_AGG, POST_AGG_FILTER