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

Formatting List Report

Started by vivek_vdc, 29 Apr 2015 01:03:00 PM

Previous topic - Next topic

vivek_vdc

Our users would like to convert some of the list reports they have to new format and add a column for variance.

List Format (current)
Metric 1...Metric 2...Metric 3..Metric 4
value 1....value 2....value 3...value 4


Requested Format
Metric 1...value 1..metric 2..value 2....variance (new field)..value 1 - value 2 
metric 3....value3...metric 4...value 4...variance (new field)..value 3 - value 4

How do I get the report layout in the requested format?

cognos810

Hello vivek_vdc,
In a new column in the List, drag and drop a table with 2 rows and 6 columns.
Row 1 Column 1 add your text label "Metric 1"
Row 1 Column 2 add your Data Item "Value 1"
Row 1 Column 3 add your text label "Metric 2"
Row 1 Column 4 add your Data Item "Value 2"
Row 1 Column 5 add your text label "Variance"
Row 1 Column 6 add your data item "Variance of 1 and 2" <<You can either create a report expression or a query data item for the computation of Metric 1 - Metric 2 values

Similarly do the same for Metric 3 and 4 in the second row of the table.
Format your table to add padding etc...


-Cognos810