0 Replies Latest reply: Nov 26, 2014 7:20 AM by Tom Creatines RSS

    Force Headings of a Pivot table

      Hi,

       

      I currently have a pivot table showing the hours of the day  :

       

      24_hour_pivot.png

       

      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