O'Reilly logo

Learning SAP Analytics Cloud by Riaz Ahmed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required