Example of Margin Percentage

This example outlines two ways to calculating margin percentage using subtotal Average or subtotal Calc. It is possible that when configuring for SubTotal Average, the result is not what the user normally would expect. Therefore configuring for SubTotal Calc might be more in line with what user normally expect from this type of calculation.

Margin percentage configured as calculated measure (M1-M2)/M2 with Pct% and SubTotal Average selected:

  M1 M2 Margin % with subtotal defined as Average
Total 400 200 74% (50% of 148%)
  0 11 0%
  37   100%
  363 189 48%

Margin percentage configured as calculated measure (M1-M2)/M2 with Pct% and SubTotal Calc selected:

  M1 M2 Margin % with subtotal defined as Calc
Total 400 200 50%
  0 11 0%
  37   100%
  363 189 48%