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?
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