Cross-tabs - Multiple columns

[KBChristy]

Can I create a cross-tab which has the following columns (current month, budget month, lya month) for each row? If so, how can I do this please? Thanks a lot!

 

[rosemaryl]

Dear KBChristy,

Please post some examples of your data. Is this information collected? Also, a definition of lya month might helpful,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[KBChristy]

Rosemary,

Thanks for replying. Here is some further information on what I want to do. All the information is held on our ERP database.

Jan Feb
Act Budget Last yr Act Budget Last yr

Brand 4,000 4,500 3,500 6,000 4,500 4,000
Retail 2,000 1,000 4,500 3,500 3,250 3,000

I hope this is sufficient and that you can help?!
Thanks

KB