In this recipe we will see how we can change the look and feel of various widgets placed on the dashboard according to certain conditions.
For instance, coloring crosstab cells based on the numeric values displayed within them, can be termed as conditionally formatting the crosstab widget.
Similarly while rendering bar charts, it is frequently required to show negative values as red color bars while positive values as green color bars. This recipe focuses on such use cases.
We will use the same setup as in the previous recipe and start with 5825-04-Sample1, which is already open in Cognos Business Insight Advanced.
In this recipe we will apply conditional formatting to our newly created dashboard—5825-04-Sample1. Perform the following steps:
1. In the top-right quadrant of the dashboard, select the list displaying Year, Product line, and Quantity and insert two more columns from the Sales (analysis) namespace. The two...