Hi All,

I am trying to use three fields "Marital Status", Age", and "Recipient" from a WebFocus table to create a report something like a spread sheet table. All fields for this “spread sheet table” are sum from the recipient corresponding to marital status and age. Also, I need grand total on the right and the bottom.

Please help, Thank you.



DV LS MC Total
Recipient Recipient Recipient Recipient Recipient
0 2 3 1 … 34
1 234 .. .. .. 600
2 1 …
3 25 …
4 60 …
5 55 …
6 37 …
7 1 …
8 4 …
9 6 …
10 7 …
11 1 …
12 6 …
13 71 …
14 12 …
… …
100 1 …
Total 523 235 1234 … 3988

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

The left hand "0, 1, 2...100" are age.

"DV, LS, MC, ..." are marital status.

TABLE FILE FILENAME
SUM RECEPIENT
BY AGE
ACROSS MARITAL_STATUS
ON TABLE COLUMN-TOTAL
ON TABLE ROW-TOTAL
END

Here's an example on car file:

TABLE FILE ibisamp/car
SUM SEATS
BY MODEL
ACROSS COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE RECOMPUTE 
ON TABLE ROW-TOTAL 
END
 

Thank you a lot.