4 Replies Latest reply: Nov 8, 2013 5:55 AM by Bruno Santos RSS

    How can I make 'Show all values' in a Pivot Table work?

    Har Schroen

      Hello

       

      I want a Pivot table to display data in this layout.

      Location

      Weekday

      Monday

      Tuesday

      Wednesday

      Thursday

      Friday

       

       

      Mor

      Aftn

      Mor

      Aftn

      Mor

      Aftn

      Mor

      Aftn

      Mor

      Aftn

      Loc_A

       

       

       

       

       

       

       

       

       

       

       

      Loc_B

       

       

       

       

       

       

       

       

       

       

      Loc_C

       

       

       

       

       

       

       

       

       

       

       

      This works well on high level aggregation.

      Making selections, columns can disappear because no data are available for that column.

      For eg.

      Location

      Weekday

      Monday

      Tuesday

      Wednesday

      Thursday

      Friday

       

       

      Mor

      Aftn

      Mor

      Aftn

      Mor

      Mor

      Aftn

      Mor

      Loc_A

       

       

       

       

       

       

       

       

       

      Loc_B

       

       

       

       

       

       

       

       

      Loc_C

       

       

       

       

       

       

       

       

       

      Wednesday and Friday afternoon are left out.

       

      I’ve tried the “Dimension” checkboxes “Show all values”, unchecked “Suppress when Values is null” and checked the “Presentation” checkbox “Always fully expanded” and unchecked “Suppress Zero-Values” to keep the layout as above.

      What should I do to keep the original layout?