This content has been marked as final. Show 6 replies
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