back

Calculate the average quantity per order.




Step 1
Click the "Quantity" column in the preview window

Step 2
Add a Sum Measure for this column

Step 3
The measure is displayed in the left view

Step 4
Click the "Quantity" column again in the preview window

Step 5
Now, add a Count Measure for this column

Step 6
The measure is displayed in the left view

Step 7
Click the calculator icon on the toolbar

Step 8
Enter the details for this calculated member. Use the arrow button to create the formula.

Step 9
You're done. The calculated member is displayed in the left view. Build the cube to see the results.


back