how to organize data in respevtive pivot tabe report filter, column labels, row labels and values

[zeedorio]

hi everybody!

i am having some trouble in using pivot table after a few years break so so if anybody might guide me what am i forgetting

i am working in garment cutting and for every new order i have to maintain a record of the measurements


1: cad pattern
2: first garment
3: first garment of first bulk cut
4: first garment of second bulk cut

every of these 4 categories have sub categories of

1: waist
2: seat
3: thigh
4: knee
5: bottom

(list is a it long i am mentioning only 5 variables for explaining myself)


now the scenario is i have
1: an order no like abc 17001
which has 4 sub catagories

1: cad pattern
2: first garment
3: first garment of first bulk cut
4: first garment of second bulk cut

every of these 4 categories have further sub categories

1: waist
2: seat
3: thigh
4: knee
5: bottom

the enigma for me here is how to organize them in rows and columns so that i can view

1: waist
2: seat
3: thigh
4: knee
5: bottom
of respective

1: cad pattern
2: first garment
3: first garment of first bulk cut
4: first garment of second bulk cut
by filtering every individual order

the solution might be a simple answer but as i mentioned i started using excel after few years break so your guidance is very much appreciated