You can use visual grid charts to show a chart for gross profit and when the margin falls below a specified value.

Start by following the MDX Calculations tutorial to create the initial report.

To create the Gross Profit bar chart:

  1. Open the Hierarchy Editor for Measures by double-clicking on the Measures hierarchy label.
  2. In the Gross Profit dropdown, select InCell Chart:
  3. Select Bar as the chart type and choose one with a value axis as the subtype.
  4. Select Current Member for the Hierarchy members to chart.

To create the Gross Profit Margin alert indicator:

  1. Select the Gross Profit Margin dropdown, and choose InCell Chart.
  2. Select 3-State Alert Icons (Red Shade) as the chart type.
  3. Select the Chart Format button to change the format, and change the first color's condition to > 0.6 and the second color's condition to > 0.55.
  4. On the Label tab, set the chart label to Alert, then select OK.
  5. Select Current Member for the Hierarchy members to chart.
  6. Select OK again to accept the chart.

When you run the report, all of the Road product group is in a warning state, and Road S8000 is in the alert state: