I've a requirement, when i select a date range of Jan till Dec, I'm getting data but the months that do not have is not coming.
To replace the empty cell with zero's is not what I'm referring to...that part i got it..
when i run the MoM report for a year...and if there is no data for April and Junei should still get it as zero's instead this is how i;m getting now:
Data range : Jan till Dec
Jan Feb Mar May July Aug Sep Oct Nov Dec ( April and June are completely missing since there is not data in the data set, but i still need to show it as zeros somehow)
Analysis>Show Empty Columns