If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Count in summary line of report

Started by dsg1, 11 May 2012 02:09:59 AM

Previous topic - Next topic

dsg1

Hi ,

I have a report which shows 4 columns : Work Area, Level,Category & Count(Level).
For Every Work Area we have 3 levels : A,B & C and for each level we can have multiple category.
In the summary line I want to show the sum of the count of the individual levels. The list view is shown below.

------------------------------------------------------------------------------------
[Work Area]             [Level]             [Category]             <count [Level]>
------------------------------------------------------------------------------------
     WA 1                  A                    C1                                     1
     WA 1                  A                    C2                                     4
     WA 1                  B                    C1                                     3
     WA 1                  C                    C1                                     0
------------------------------------------------------------------------------------
WA 1 [level A]:5  [level B]:3  [level C]:0                                  8
------------------------------------------------------------------------------------
     WA 2                  A                    c1                                       0
     WA 2                  B                    C1                                       2
     WA 2                  B                    C3                                       2
     WA 2                  C                    C1                                      5
     WA 2                  C                    C2                                      1
------------------------------------------------------------------------------------
WA 2 [level A]:0  [level B]:4  [level C]:6                                  10
------------------------------------------------------------------------------------
     WA 2                  A                    C1                                     1
     WA 2                  B                    C1                                     1
     WA 2                  C                    C1                                     1
------------------------------------------------------------------------------------
WA 2 [level A]:1  [level B]:1  [level C]:1                                  3
------------------------------------------------------------------------------------

Need help to resolve this issue.

Thanks
Dsg.

colt

Hi dsg1,

as I understand your post:
You have already created a report with the 4 columns, but you don't know, how to do the summary line ?

I guess, the report you have is a list report. To add summary lines, you first have to go to list properties
Grouping & Sorting and tell the report to be grouped by [Work Area] and [Level].
After that you can add summary lines by marking measure column [count[Level]] and clicking on the Summary Symbol on the Pane.
Now summary lines are added for each grouping + overall.