6 Replies Latest reply: Dec 2, 2013 6:57 PM by Said Farid RSS

    Show all of pivot 2nd dimension

      Hi!

       

      Lets say I need a report on my clothes store sales.

      I choose a pivot table and start with product category as my first dimension (shirt, t-shirts, sweaters and so on). As my second dimension I want size (S,M,L).

      If I by any chance not sold any size M of a product category that row will not show.

       

      How to accomplish that all, possible, sizes always shows for all product categories?

       

      Attaching a simple example where I would like to see T-shirts, M, 0

       

      regards

      thomas