2 Replies Latest reply: Oct 4, 2017 11:38 AM by Mike Hann RSS

    Show previous month data, when there is no record

    Mike Hann

      Hey, here is the screenshot of my current pivot table (QVW file attached)

       

      sample.PNG

       

      What I am trying to achieve is something like:

       

      sample2.PNG

       

      If it is possible, I would like to be able to do that using expression.

      Does anybody have any idea? thanks before