4 Replies Latest reply on May 13, 2013 10:50 AM by Tracy Rodgers

    Showing column/row header with no data

    Andrew Yan

      Hi all,

       

      Say I've a sales table with a sales data field and my last sales happened on Dec 30, 2012.

       

      I'd like to build a worksheet which shows the date Dec 31,2012 with zero or no value. Can that be done without SQL tricks?

       

      The reason I try to handle this within Tableau is that my sales table have many dimensions. My data extract will be huge if I'm padding records for all the permutations.

       

      I know question may've been asked many times. Please direct me to the right discussion if it's already been answered.

       

      Thanks!

       

      - Andrew