Hi everyone,
I have a pivot table with 246 rows representing rooms and, for the month of January, 31 columns, representing each day. The data field (count of date reserved) simply shows 1 for occupied and 0 for unoccupied.
If room 1 has even a single date reserved during the month, it shows 1 in the column representing the date the room was occupied, and shows 0 on the remaining 30 dates that it was unoccupied. This is exactly what I want, and the pivot is fine up to this point.
If it happens to be the case however, that room 1 has no dates reserved for the entire month of January, Excel doesn't display room 1 in the pivot table. I fear the same would be true if there was no occupancy in any of the 246 rooms on January 1, that Excel would also not display January 1 as a column.
How do I trick Excel to include all 246 rooms and all dates in January in my dataset?
Any suggestions?
I have a pivot table with 246 rows representing rooms and, for the month of January, 31 columns, representing each day. The data field (count of date reserved) simply shows 1 for occupied and 0 for unoccupied.
If room 1 has even a single date reserved during the month, it shows 1 in the column representing the date the room was occupied, and shows 0 on the remaining 30 dates that it was unoccupied. This is exactly what I want, and the pivot is fine up to this point.
If it happens to be the case however, that room 1 has no dates reserved for the entire month of January, Excel doesn't display room 1 in the pivot table. I fear the same would be true if there was no occupancy in any of the 246 rooms on January 1, that Excel would also not display January 1 as a column.
How do I trick Excel to include all 246 rooms and all dates in January in my dataset?
Any suggestions?
Last edited:
