1. Within Analysis Manager, expand the Module 18 database, expand the Cubes folder, right-click Sales, and then click Edit.
2. Right-click the Calculated Members folder, and then click New Calculated Member.
3. Type Gross Margin in the Member Name box.
4. Expand the Measures dimension within the Data box, expand MeasuresLevel, drag Store Sales to the Value expression box, type a minus sign (-), and then drag Store Cost to the Value expression box.
5. Click OK.
6. Right-click the Calculated Members folder, and then click New Calculated Member.
7. Type Average Selling Price in the Member Name box.
8. Expand the Measures dimension within the Data box, expand MeasuresLevel, drag Store Sales to the Value expression box, type a division sign (/), and then drag Unit Sales to the Value expression box.
9. Click OK.
10. Right-click the Calculated Members folder, and then click New Calculated Member.
11. Click Customer in the Parent dimension list.
12. Click the Change button, click All Customer, and then click OK.
13. Type Average Customer Value in the Member Name box.
14. Type the following text in the Value Expression box:
Avg([Customer].[Customer].Members)

15. Click OK.