In the example below, the sales figures are in local currency of COUNTRY. I like to have column totals on SEATS within each COUNTRY. There seems no provision in GUI report painter to do what I want. Is there a simple way to do this? Thanks.

DEFINE FILE CAR
CURRENCY/A3 = IF COUNTRY EQ 'JAPAN' THEN 'YEN' ELSE 'EUR';
END
TABLE FILE CAR
SUM 
     SALES
     CURRENCY
BY COUNTRY
SUM 
     SALES
BY COUNTRY
BY CAR
ACROSS SEATS ACROSS-TOTAL
END
  

This message has been edited. Last edited by: Hua,

Hua, I'm not sure I understand your requirement completely. Is this perhaps what you need?

DEFINE FILE CAR
CURRENCY/A3 = IF COUNTRY EQ 'JAPAN' THEN 'YEN' ELSE 'EUR';
END
TABLE FILE CAR
SUM 
     SALES
     CURRENCY
BY COUNTRY
ON COUNTRY SUBTOTAL SUM. SALES
SUM 
     SALES
BY COUNTRY
BY CAR
ACROSS SEATS ACROSS-TOTAL
END

It would help if you provided a sample output illustrating what you expect.

Thanks for your reply, njsden. Here is the sample output:

 
				SEATS			
				2	4	5	TOTAL
COUNTRY	SALES	CURRENCY	CAR	SALES	SALES	SALES	SALES
ENGLAND	12000	EUR	JAGUAR	0		12000	12000
			JENSEN		0		0
			TRIUMPH	0			0
*TOTAL ENGLAND			0	0	12000	12000  <====== TOTAL PER SEAT PER COUNTRY

FRANCE	0	EUR	PEUGEOT			0	0
*TOTAL FRANCE	0		0	0	0	0      <====== TOTAL PER SEAT PER COUNTRY
 	
ITALY	30200	EUR	ALFA ROMEO	25400	4800	30200
			MASERATI	0	0	0
*TOTAL ITALY				25400	4800	30200  <====== TOTAL PER SEAT PER COUNTRY

JAPAN	78030	YEN	DATSUN		43000		43000
			TOYOTA		35030		35030
*TOTAL JAPAN			0	78030	0        78030  <====== TOTAL PER SEAT PER COUNTRY

W GERMANY	88190	EUR	AUDI			7800	7800
			BMW		8900	71490	80390
*TOTAL W GERMANY			0	8900	79290	88190  <====== TOTAL PER SEAT PER COUNTRY

							
 

How about this?

DEFINE FILE CAR
CURRENCY/A3 = IF COUNTRY EQ 'JAPAN' THEN 'YEN' ELSE 'EUR';
END
TABLE FILE CAR
SUM 
     SALES
     CURRENCY
BY COUNTRY
SUM 
COMPUTE C_SALES/D10.2 = SALES; AS 'SALES'
BY COUNTRY
BY CAR
ACROSS SEATS ACROSS-TOTAL
ON COUNTRY SUBTOTAL SUM. C_SALES
END

Please disregard the code above. I just tested it and the results are far from right.

This one is better (I hope ):

DEFINE FILE CAR
CURRENCY/A3 = IF COUNTRY EQ 'JAPAN' THEN 'YEN' ELSE 'EUR';
C_SALES/D10.2 = SALES;
END
TABLE FILE CAR
SUM 
     C_SALES AS 'SALES'
     CURRENCY
BY COUNTRY
SUM 
     SALES
BY COUNTRY
BY CAR
ACROSS SEATS ACROSS-TOTAL
ON COUNTRY SUBTOTAL SUM. SALES
ON TABLE NOTOTAL
END

Awesome! Didn't think of using a different fieldname at detail level.
Thanks again, njsden!

Hua

I am no expert with the GUI but I think you can achieve that effect using the Report Painter, unless multi-verb request are disallowed there.

You're welcome! Please let us know if your adventure with Report Painter proves to be fruitful!

- Neftali.

Quite intersting Neftali. you have readymade solutions. such a quick response.

quote:

Originally posted by njsden:
You're welcome! Please let us know if your adventure with Report Painter proves to be fruitful!

- Neftali.

As fruitful in GUI. Use different field name for sure when summing the same field in mult-sorts.

Hua

quote:

you have readymade solutions

Not really Ram

As Hua had already done what we expect from anyone who asks for support in this forum (that is: do some research first, try by themselves and post workable sample codes using any of the IBI-provided files) it was rather easy to try different options until reaching the intended output. I even initially proposed some solution that was nowhere close to what Hua needed but thankfully it did not create more confusion (I guess ).