Calculated Field in Crosstab Query

[bryan0]

Hello all, I have a CrossTab query that looks like this after being run:

Vendor	USA	Mexico	France	Germany
Burger King	$500	$200	$400	$600
McDonalds	$250	$300	$300	$400
Subway	$700	$450	$350	$650

I'd like to be able to add two columns to add certain columns together, without using a separate query to perform calculations on my CrossTab. Here's how I want it to look:

Vendor	USA	Mexico	France	Germany	Americas	Europe
Burger King	$500	$200	$400	$600	$700	$1000
McDonalds	$250	$300	$300	$400	$550	$700
Subway	$700	$450	$350	$650	$1150	$950

Is this possible using expressions? Or must I use a separate query? Thank you!

[June7]

Only 4 countries? Can mimic a CROSSTAB with IIf expressions. Review http://datapigtechnologies.com/flashfiles/crosstab.html

[bryan0]

That will do it, I have 20 countries but can still apply the same logic by summing the IIF expressions. Thanks!