1 Reply Latest reply on May 24, 2016 9:39 AM by Nicholas Hara

    Creating dummy record in cross tab

    Rajesh veerabhadraiah

      Dear All,

       

      I've a requirement to display crosstab with everyday data (displayed based on "Date value")...

      This I'll lookup from a Data table, but this table might not have every day date value (which means record might be missing for a day or two)..

      I need to show Default value as zero for that missing date record...

      Tableau1.png

      Tableau2.png

       

      appreciate any sagesions  and advices

       

      -Rajesh