Crosstab Question

[Yula]

I am trying to see results in the following way:

Total Imp 1sided total Two Sided total
Container ID 12345 10 2
4
56789 15 3
6
52897 9 5
2

I am working with the Cross Tab Query Wizard and I cannot get the 1sided
and 2sided totals to show up in the wizard. can someone explain to me how to
do this in the most simplistic terms.

Thank you so much in advance!
Yula

 

[KARL DEWEY]

I am working with the Cross Tab Query Wizard and I cannot get the 1sided
and 2sided totals to show up in the wizard.
The labels 1sided and 2sided would be the data from a field.

Post your data structure - field names with datatype. Also sample data.
Your data example is not valid data as container 12345 1sided quanity (2)
added to container 12345 2sided quanity (4) will not total 10 as shown.