Thank you for your prompt response and that link was very helpful. Now I have my "Market" Dimension on Rows, and "Date Granularity" Calculated Field on Columns.
However, there is another calculation that I need to create to show me whether or not there is a record for the specific day.
If you could assist me with this calculation it would be greatly appreciated.
Pl create a sample workbook, You would appreciate that My guessing the things wont help you. you can use superstore dataset.