Grouping and Summary for Cognos Impromptu Reports 1

[micrvill]

Hi All!

is it possible to group a specific column but it will still display the data per line? I need to get the summary for these groups.

example:


RAW DATA:

DATE ACCOUNT CODE ICN AMOUNT

03032005 0001 A 1 100
03032005 0001 A 2 100
03032005 0002 A 3 50
03032005 0002 B 4 20
03032005 0003 A 5 25

TOTAL 295

I WANT THE SUMMARY FOR ACCOUNTS AND CODE. If I group it by account then by code it will be displayed this way:

DATE ACCOUNT CODE ICN AMOUNT

03032005 0001 A 1 100
03032005 2 100
____________________________________________

code total 200
account total 200

____________________________________________
03032005 0002 A 3 50
____________________________________________

code total 50

____________________________________________
03032005 B 4 20
____________________________________________

code total 20
account total 70
____________________________________________
03032005 0003 A 5 25
____________________________________________

code total 25
account total 25

report total 395

**************************************************

what i want to display is this format:

DATE ACCOUNT CODE ICN AMOUNT

03032005 0001 A 1 100
03032005 0001 A 2 100
---------------------------------------------
code total 200
account total 200
---------------------------------------------
03032005 0002 A 3 50
---------------------------------------------
code total 50
--------------------------------------------
03032005 0002 B 4 20
--------------------------------------------
code total 20
account total 70
--------------------------------------------
03032005 0003 A 5 25
--------------------------------------------
code total 25
account total 25

report total 395

TOTAL 295

 

[griffindm]

micrvill,

This is easy to do. Group on account and code, then add account and code to the query again, either by dragging them from the catalog, or by making new calculated columns that point to the original query items. These 'extra' copies of the account and code will NOT be suppressed on multiple rows and will appear just like ungrouped data.

Hope this helps,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[micrvill]

perfect! thanks!!