I have Report Like This Month name and amount and balance. in this report I apply filter like current year. That is working fine when data is available. My requirement like this
In my application Present month data is not there in that place I want display zeros.
Ex:Month_name amount blance
Jan 10000 5000
Feb 0 0
to display Month without data, you must change your RPD by adding a Left Join between your time dimension and your fact table or add a left join directly in your fact source (left join between time and fact).
After you could work on your measure and add formula to display 0 when there is no value.