Show all of pivot 2nd dimension

[#1]

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

[Anonymous]

Hi

     Hope the attached qv file will be helpful for your requirement

Regards

Ashok

[#3]

Hi, no. Only difference is that if I select the T-shirt product I get a row that says -, 0

I'm thinking of calculating all possible outcome and where (pseudo) nbr>0=nbr else 0

[v_iyyappan]

Hi,

     I attached sample QV file. Hops its helpful for u.

Regards,

Iyyappan

[#5]

No, still missing Size M for T-shirts...

I'm using QV 10 SR3 if that's maybe the issue?

[v_iyyappan]

Hi,

      I attached two Image for Your requirments .

1 . First one is whether u expect pivot table display the data like this.

2.  Its correct means use the Second image .

Regards,

Iyyappan

[emteam162]

Hi all,

Have you solved the problem

Please, share the solution.

Many thanks

Emteam