4 Replies Latest reply: Jan 14, 2016 3:51 PM by Alec Smith RSS

    Create Zero Values On Daily Records When No Activity

    Alec Smith



      I am reporting on individual store's daily sales across a number of stores.  Besides showing each store's daily sales, I need to also show the stores that did not post any sales for that day as well.


      The question is how can I show the stores with "zero" sales as I am showing sales for each store?


      I have a following tables in the data model. The master calendar uses the functions Min(Date) and Max(Today()) functions in the script that creates a date everyday in the master calendar.   


      Fact Table

      • Date
      • Store
      • Sales


      Master Calendar

      • Date
      • Month
      • Year


      Thank you in advance for assistance on this issue.