1 Reply Latest reply: Sep 5, 2017 12:20 PM by Ruben Marin RSS

    Show all hours even when data doesn't exist

    Justin Dallas

      Hello Folks,

       

      I'm working with a Pivot Table, and I have a field that represents the Hours.  As of now, my pivot table only shows the hours for which data exists, which makes sense.  But I would also like to show all the hours (0-24) no matter  if the data exists or not.  Generally, I would create a Stub Item to fill out the data range, but that doesn't work when the user begins making selections and filtering.

       

      Capture120.PNG

       

      Any help is greatly appreciated.