Add extra columns to Cross-tab

[fredong]

Currently I have a cross tab that shows vendors on rows and Salesperson on columns and totals on Summarized field.I need to add a few columns such as vendor quotas and variance a that runs side by side with totals. Below is my current cross tab


John Dave Peter Totals
PEPSI 1000 2000 3000 6000
Coke 2000 4000 5000 11000
RC 4000 5000 6000 15000
Totals 7000 11000 14000 32000

and I need to add 2 columns vendor quotas and variance to look like below.Please advise. Thanks
(Variance = totals - QUOTAS)

John Dave Peter Totals QUOTAS Variance
PEPSI 1000 2000 3000 6000 50000 -44000
Coke 2000 4000 5000 11000 10000 1000
RC 4000 5000 6000 15000 12000 3000
Totals 7000 11000 14000 32000 72000 40000

 

[Wallie12]

I would address this differently, instead of using a crosstab, I would use a multi-column report. This would allow you to add the additional columns.

 

[fredong]

what is a mutlti Column reports?