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

      Hello,

       

      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.