Hi,
I currently have a pivot table showing the hours of the day :
My problem is when the document is filtered and there are no values for certain hours of the day the pivot naturally reduces. Is there a workaround to force the full 24 hours to stay in place?
Many thanks,
Tom