Hello,
I created a pivot table. The data has 2 columns, wk and villa number. The pivot shows me the week number and the villa number for that particular week. Now, I have certain weeks that do not have any data. So my pivot skips (doesnt' show) that week. Is there a way for the pivot table to show me that week and show a blank or a 0 value if the week doesnt have a villa number?
thanks,
George
I created a pivot table. The data has 2 columns, wk and villa number. The pivot shows me the week number and the villa number for that particular week. Now, I have certain weeks that do not have any data. So my pivot skips (doesnt' show) that week. Is there a way for the pivot table to show me that week and show a blank or a 0 value if the week doesnt have a villa number?
thanks,
George