6 Replies Latest reply on Dec 6, 2017 5:10 AM by Marc Chassot

    missing value for december of last year

    Marc Chassot

      Hello

       

      I want to create a running sum per year(2016 and 2017) and display them on the same graph for visual comparison. There is no value for december 2017 but I want to display it anyway (the running sum should return 14 not 0 or null)

      tableau.jpg

      I have already tried analysis -> table layout -> display empty columns

      I have already tried to add ZN() functions which has a correct effect on all columns except december 2017

      I have already tried other solutions like lookup with number of records

       

      Do I miss something ?

       

      Can anyone help me?

       

      Thank you