I am doing rolling forecast where my condition is If i am planning for RF_JUN, In input schedule all actual data from Jan to May should appear and all JUL to dec i need to get Previous year data forcast.
I have 3 dimensions in Row i have Accounts and in coloumn i have category & Time.
Another issue is,
I have parent & child hierarchy and i used supress zeros, But when i dont have data for children all base level members are going to be zero out includign parent.
I want to exclude parent from supression.
Is there any way out?