9 Replies Latest reply on Dec 8, 2016 11:41 AM by Vincent Baumel

    Need help with Calendar layout

    Vincent Baumel

      I've got a highlight table colored according to sales, but on days without sales it shows blank. This becomes a problem when 11 of my months have sales 7 days a week but one month doesn't have any Sunday sales. Is there a way to mandate that my worksheets include days that might not have any sales reported?

       

      Each month is a worksheet with DATEPART('weekday', [Invoice Date]) on Columns and DATEPART('week', [Invoice Date]) on Rows.