Break and Compute Problem to display report

[jagadish]

Hi all

I have a big problem with break and compute....

i have to select Date,store,number,sum(a) from mytab groupby Date,store,number

I want the report to be display in this way...

Date Store Number Sum(a)
----------- ----- -------- ------
01-Jan-2000 10 90 1000
70 1000
60 5000
-------
7000
-------
01-Jan-2000 20 100 200
343 300
223 500
-------
1000
-------
8000
------

so please let me know how can i compute sum and break on each .....columns..


thanks

[Maverick2000]

Hi,
I Understand you want SUM of "sum(a)" for all the Stores.

Try this:

BREAK ON STORE SKIP 1;
COMPUTE SUM LABEL 'TOTAL' OF XYZ ON STORE;
select Date,store,number,sum(a) XYZ from mytab
groupby Date,store,number;

Hope this works for you