Issue with Periodic Values on a YTD Model.
I have loaded Transaction Data into a YTD Model and I am using MEASURES = PERODIC in Reporting to show Periodic Values month wise.
My issue is that for some months it is having 0 values (in my case 2015.12 = 0).
So when 2015.12 = 0, it is loading aggregated value upto 2015.11 into 2015.12 with negative sign (for me upto 2015.11 = 11000 then 2015.12 = -11000).
I have to show 2015.12 = 0 only. But the default behaviour for YTD Model when used with MEASURES = PERIODIC in report is like this only.
Please post your suggestions how to achieve this (i.e 2015.12 = 0).
Thanks in advance!