Crosstab - show $ and # of units side by side 1

[lmctech]

I'm using XI, backend is SQL and I'm using a command to get around some performance issues.

We need to have a 13 month rolling view of the $ amts and # of units side by side for each month.

I suspect in order to put the two side by side, I'm going to have to use a manual crosstab, but I'd LOVE to avoid that if possible because its going to get downright dirty.

Jan-08 Feb-08 Mar-08
Product A $500 33 $322 43 $907 52
Product B $122 21 $340 11 $808 13


I remember seeing some slick trick a while back on how to do this, but for the life of me, I cant remember it now!

 

[lbass]

Within the crosstab expert, go into the customize style tab->summarized fields->horizontal->show labels (if you wish).

-LB

 

[RepRider]

wow! I actually knew the answer to that one!!!