Hi,
I'm trying to create this pivot table and come across some weird situation here:
View attachment 39278
We have 2 types, let's say "u" & "h" that will be used as filters for "book" column. When there's a booking, it could be "u" or "h" then they'll show up fine in pivot table. The problems come when there's zero booking for a day, I don't know which type to assign to or do I have to duplicate "0" value and assign for both?
I'm trying to create this pivot table and come across some weird situation here:
View attachment 39278
We have 2 types, let's say "u" & "h" that will be used as filters for "book" column. When there's a booking, it could be "u" or "h" then they'll show up fine in pivot table. The problems come when there's zero booking for a day, I don't know which type to assign to or do I have to duplicate "0" value and assign for both?