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:
Also, when I filter on last 2 months, the MonthOnMonth%Difference is null for my previous month
Can anyone help?
Thanks in advance,
Ajinkya