Pivot Table & Showing items with no data

[mtterry]

I have two merged data sources, one shows a count of events that happened each day, and the other is a date table that contains all of our company holidays and weekends. I've merged the files, and then filtered out all holidays and weekends in the merged file. I then created a pivot table showing how many specific events happened each day, with a filter by location. The issue I'm running into is that there are certain locations where the event never occurred on days that aren't holidays/weekends, and I want them displayed (blank or zero is fine) in the pivot table, but when I go into the field settings and select 'display items with no data', excel defaults to showing every single day in the year, even the dates I have filtered out of the merged table. I only want to see dates that I haven't filtered out where the event hasn't occurred, how do I achieve this?

 

[ashakantasharma]

You can do so by the use of conditional formatting in excel.
Select the PT and go to Conditional Formatting and create a new rule
Select "Format only Cells that contain" and provide the details like (blank) and select format cell option and select custom option and give formatting as ";;;"