Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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