1 Reply Latest reply on Oct 1, 2018 9:37 AM by chris mutchler

    How To Display 0 when No data Present In Database

    susheela.hegde

      Hi All,

       

      In attached workbook, I do not have data for CA Market on 9/19 , how ever I would like to see the data as 0 for CA.ME and VA for 9/19.

       

      If I take of the Filter (Sheet 2), it works perfectly fine but I have to add the filter (With Filter sheet) . When I add the filter i do not get any value for these markets. If there is no value then it should be displayed as 0.

       

      Can we do this without reshaping the data?