Calculated Measures

You can create your own calculated measures and use them just the way you do it with ordinary measures. To create a new calculated measure press the right mouse button anywhere in the measures list. You will see the context menu, which will give you an ability to add calculated measures:

After pressing “New Measure …” item you will see a wizard that will help you to create calculated measure:

The wizard lets you choose the type of a new calculated measure from six different options:

• Relationship;
• Parallel Period;
• Growth;
• Rolling;
• Period to date;
• Custom MDX;

The last option is for experts that are familiar with MDX querying language. All other options will let you create new measures in an easy wizard mode.

For example, let’s create a calculated measure of an average sales amount by orders – the ratio of sales amount to orders count. Select a “Relationship” measure type:

Press “Next” and fill in the fields in the next window as it is shown in the picture:

After pressing “Finish” you will see the folder for calculated measures in the measures list and it will contain a new measure:

Now you can use that calculated measures the same way you use the other measures. Just drug the new measure into the “Measures” designer and you will get the expected result:

To edit or delete calculated measure just click the right mouse button on the corresponding measure in the list and select “Edi” or “Delete”, respectively: