Business users will need to focus on crucial data in the analysis, so displaying formatted data is very important. One analysis may consist of hundreds of rows but users should be able to focus only on important ones from the point of business view. In this section, we're going to enable conditional formatting in the analysis. We'll use these columns in the sample analysis:
The
Regionattribute columnThe
Stateattribute columnThe
Dollarsmeasure column
We are going to enable conditional formatting on the Dollars column. We'll also change the sort order of the result set.
We're going to create a sample analysis with the mentioned columns. Then we'll need to open the Column Properties of the
Dollarscolumn. We'll click on the Add Condition button in the Conditional Format tab. All available columns will be displayed. The condition of theDollarscolumn values may be dependent on another column's value. But we're going to use theDollarscolumn's values...