Adding together 2 cross tabs

richpoulse

Hi,

I have 2 individual cross tabs which I need to add together but currently no idea how to. Anyone ever done this before? Any help would be greatly appreciated.

eg

Europe (Cross tab 1)
Apples | 300
Pears | 560
Bananas | 700
Subtotal | 1560

America (Cross tab 2)
Apples | 50
Pears | 400
Bananas | 900
Subtotal | 1350

Total | 2910 <--- This is where I need to be

Thanks!

loume

You can use

Europe | America | total
Apples | 300 | 50 | 350
Pears | 560 | 400 | 960
Bananas | 700 | 900 | 1600
Subtotal | 1560 | 1350 | 2910


in the one crosstab