Parallel Period

In the previous chapter you created a calculated measure of “Relationship” type. In this chapter you will see the example of measure of “Parallel Period” type.

For example, let’s create a measure showing the value of “Reseller Sales Amount” in the same month of the last year, and use this measure to compare the bikes sales in different months of this and previous year.

Add a new measure to the measures list using the corresponding context menu option:

When creating a new calculated measure select “Parallel Period” measure type and press «Next»:

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

The selected Parallel period type at the bottom (Value from parallel period) means that the value of the measure selected in the “Base Measure” field (“Reseller Sales Amount”) will be shown. The Time “Hierarchy” field points to the hierarchy that will be used to count the parallel period. And the values in the “Level” and “Periods” fields mean that the data for a time period, that was 12 month before the current period, will be shown.

After filling in all fields press «OK» and you will see a newly created measure in the measures list:

Place the months of the year 2017 on the columns of your table:

Place the “Bikes” category from “Product Categories” hierarchy into the context, thus you will see only the sales data for bikes:

After that place two measures on rows: “Reseller Saves Amount” and newly created “Reseller Sales Amount Parallel Period”. You will get the following report:

Add a chart to your report. Set the argument to columns and remove the legend:

After that you will get the report like this:

In the chart you can see that two bars are corresponding to every month: red one stands for the current “Reseller Sales Amount” value and a blue one – for the value of that measure in the same month of a previous year.