Cross Tab

[sto837]

Hi,

Is there anyway to create the following Cross Tab report

ItemA ItemB ItemC SubTotal(ItemB+C) Total Total%
Jan 1 2 3 5 6 5/6=83%
Feb 2 3 4 7 9 7/9=78%


Thanks

 

[lbass]

Yes. How many items are there? If there are only a few, then create a manual crosstab.

-LB

 

[sto837]

Thanks for your quick respond. There are around 6 or 7 items, so I'm wondering if that can be done automatically via cross tab built-in functionality.

 

[lbass]

For six or seven, you should still do a manual crosstab as it will be easier.

-LB