Editing the formula

The Tutorial2 report displays the variance between the actual and budgeted gross margin figures in respect of all channels, all points of sale, and all regions.

To display the variance in the figures for actual units sold, instead of the gross margin, we can amend the formula:

  1. Open the Tutorial2 report.
  2. In Design Mode, click cell C11 and click Edit OLAP formula.
    The Edit OLAP Formula dialog is displayed.
  3. Click the Browse button next to the Measure dimension.
  4. Click Units and click OK. Click OK again.
    Note: The figures in the report now represent units instead of the gross margin. To change the formula in this way is simple and might be suitable in a report for personal use. But if the report is to be used by other users, we need to let them choose their own views of the data.