Period to date

“Period to Date” calculated measure type is used to show a total or average value of some existing measure from the beginning of some period to the current date.

For example, if you need to draw a chart representing the growth of total sales amount during a year, you can create a calculated measure, showing the total amount of sales from the beginning of the year to a current date. Let’s create such a measure. While creating a new measure, select “Period to Date” measure type:

Press «Next» and fill in all fields in the next window as shown:

Operation type selected at the bottom defines that the total value of the measure selected in the “Base Measure” field (“Reseller Sales Amount” in our case) will be shown. In the “Time Hierarchy” field you have to select the time hierarchy. The total value will be calculated starting from the beginning of the corresponding period from the level set in the “Level” field. If you set the “Calendar Year” level, you will get the totals from the beginning of the year.

Press «OK» and the new calculated measure will be added to the measures list:

Let’s create the charts of total sales growth during the year 2017 for every country outside the Americas. First drag the “Date.Calendar” hierarchy on columns and select all month of the year 2017:

Then drag the “Geography” hierarchy on rows and select all countries except “Canada” and “United States”:

Drop a just created “Reseller Sales Amount Period to Date” measure inside the table. And put the hierarchy “Product Category” with only “Bikes” category selected into the context.

Your page should look like this:

Change the view mode from table to chart, using the corresponding option from the toolbar:

In Chart Properties select the columns as an argument and change the type of the chart to Line:

You will get this kind of report with the charts of total sales growth of bikes in different countries: