Possible to show previous month value as this month in pivot based on period dimension.

[stevietm]

Hi All,

I just want to find out if it is possible to show a value of a previous month as the current month if the current month is 0.

See attached an example. This is based on an accumulation of every month in a pivot table with the dimension as the period.

Current output measure:

Sum(Aggr(
RangeSum(Above(
Sum({<FinYear = {'2019','2018','2017','2016'}, ManagementMap4 = {'XXXXXXXXXXX'}, CompanyName>} Amount)
, 0, RowNo()))
, CompanyName, Period))*
Avg(1)

Thanks in advance

Regards

Stevie Marincowits