1 Reply Latest reply on Feb 5, 2018 12:54 PM by Deepak Rai

    How to show missing months data either to empty or zero's

    lakshminarayana.m

      Hi,

      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..

       

      For example:

      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)

       

      Please advice.