Keyfigures for previous month
In my report i have a set of keyfigures. Some of them must show values for current month and others the previous month.
In my query i use 0calmonth, restricted by 0i_cmnth. The user can choose any interval.
It works fine when i use variable offsets in keyfigures, but when i put 0calmonth in rows, BEx does not know what value to substitute at the intersection of the months and keyfigures for previous months.
How can i solve that problem?