-
Break and Compute Problem to display report
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
-
Check this out
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|