Growth

Calculated measure type “Growth” lets you create a measure that will show an absolute or relative growth of another measure.

Let’s create a measure that will show a relative growth in percents of “Resellers Sales Amount” measure in this month comparing to the previous month, and use that measure to show the sales growth of bikes.

Add a new calculated measure of “Growth” type:

In the next step fill in the fields as it is shown in the picture:

“Base Measure” field points to the measure the growth of which we are interested in. The Time Hierarchy field is for selecting the hierarchy that will be used to count growth, in most cases the time hierarchy (like “Date.Calendar”) should be selected here.

After filling in all fields press «OK» and you will see the new calculated measure in the list:

In the report from the previous chapter remove the “Reseller Sales Amount Parallel Period” measure from rows:

Place the newly created measure “Reseller Sales Amount Growth %” instead.

You will get the following report:

In the chart for every month you can clearly observe the sales amount and its growth in percent comparing to the previous month.