Need Multiple colums at same level in a crosstab

[joteknh]

I am having a hard time creating a crosstab that
looks as follows;

11/2009 10/2009 ....
Qty | Amount Qty |Amount ...
Row 1 10 $100 5 $230
Row 2 ...

I am not able to set the crosstab to look like this it ends up with the Amount under the Qty. I want the column cells for each month to be split into two different columns data cells qty and amount for each month. The rows are item numbers.
Is this possible and how.

Thanks very much for any help

 

[joteknh]

I found my answer , needed to change the summary field checkbox in the Cross-tab expert

 

[raja2008]

Using Crystal XIR2

Can you please explain how you did it.
I'm looking for the same thing to be done in my report

Thank you

 

[raja2008]

Got it.

Just so if anyone is wondering:

The option is in the Customize style tab.

Summarized fields Horizontal or Vertical.