Let me explain in better way. The report requires that how many time a representative visited to a store in a day through out the entire month date wise. There are 50 representatives as dimension on left side of a pivot table, visit_date as column dimension and measure as count of activity_id. So it may happen that any any representative may on leave and not going to a store and we won't have that day data in our table which is visit_date. So I have created a master calender for a continous date and there I have created a visit_date which is connected to visit_date of my data table.
Now on the report part for example 5th of december 40 representative visit are available however 10 reps are showing as - in greybox that means those 10reps were not visited. So the requirement is that - in greybox of a pivot table should show zero instead of - in greybox.