Creating formatting rules

The Formatting Rules section under the Styling tab lets you create rules, wherein you specify how to format dimension members and hierarchies. In this exercise, you will create a couple of rules to highlight the net revenue earned by the sales manager Kiran Raj in the three states. Execute the following steps to achieve this task:

2. Select the table, and open the Styling tab under Designer. Click on the Add Formatting Rule link in the Formatting Rules section. On the Formatting Rule panel, enter State Rule (A) for the rule name. Click and hold the first cell showing 50.05 (B) in the Net Revenue column and drag down to select all the three net revenue figures for Kiran Raj. As you select these three cells, relevant information (C) appears under the Selected Content area in the Formatting Rule panel. From the Level list representing location, select Self & Children (D), as shown in the following screenshot:

The checkboxes in the Selected Content section are provided...