i have a calendar view i used pivot table to make it , the problem i'm having is that when i select the day it shows only that day and other days dissapear( check attached images). so what i want is when i select a day unselected day dont dissapear but they remain with a grey backgroun. your help will be highly appreciated.