How to do it…

  1. Once the data is loaded, open the App overview window and create a new sheet.
  2. Enter the Edit mode by clicking on .

.

  1. Drag across the  object from the Assets panel on the sheet.
  2. Name it Moving Annual Total.
  3. Add [MAT MonthYear] as the dimension.
  4. Next, add the following measure and label it MAT Sales:
SUM({<[MAT 
MonthYear]={">=$(vRolling12Months)<=
$(vMaxMonth)"}>}Sales)
  1. Save the application and click on .
  2. Under Appearance, select the chart style as .
  3. Check the Show Data points.
  4. Switch on the Value Labels options to show values on each data point.
  5. Under X-Axis:MAT MonthYear, switch off Continuous and disable Use Continuous scale.
  1. The final trendline chart should look as follows:
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset