Using a single formula to hide rows in a report

This example shows how you might use the Formula option in the Row Properties dialog box.

In this example, a row is hidden when a particular year and version are selected from combo boxes.

This example uses dimensions of the Analysis cube.

  1. Insert two combo boxes. Name one Years and the other Version.
  2. Link Years to the Period dimension and Version to the Value Type dimension.
  3. In a cell, specify Hide this row when 2017 and Budget are selected .
  4. Right-click the header of the row in which you entered the text and select Rows.
  5. Select the Formula option and specify this formula:=IF(ReportObjects.version.Alias="Budget",IF(ReportObjects.years.Alias="2017","false","true"),"true").