Microsoft Office Tutorials and References
In Depth Information
Figure 6-48. Setting the number format
Click on New Target to create a second target metric. In this case, instead of breaking even,
our goal is to do better with a promotion than without one. Therefore, we will compare
the gross profit margin obtained with a promotion to the margin obtained when the
promotion is “No Discount.”
Set the name of the new target to “GP% vs. no Discount.”
Set the Compare to field to “Gross Profit Margin.”
Click on the link to set the data mapping, and select the Gross Profit Margin measure just
as you did when setting the actual metric.
Instead of finishing the dialog, we will add a filter to find the value of the gross profit
margin in a specific case. Start by clicking on the New Dimension Filter button under
"Select a dimension". (See Figure 6-49 .)
Search JabSto ::

Custom Search