Cumulative Total (OLAP) 
Purpose
The Cumulative Total template is an OLAP dynamic calculation template with which you can build queries that cumulate the value of a measure over a specific date range.
In the result, the measure is first cumulated over the date range specified, and the starting cell displays that initial period's sum. Thereafter, each cell in the grid displays the accumulation of the previous sum plus the sum in the next time period, and so on.
This kind of query is particularly useful if you have a specific target to hit by the end of the year, for example, and you want to track your progress toward it throughout the year.
You should use this template if you would like to address business questions such as the following:
What is my monthly year-to-date expense total?
Prerequisites
You have an OLAP data service configured as a BI system.
Process Flow
After using the BI Query Wizard to select an OLAP data service and the Cumulative Total template, the wizard steps you through the following process flow:
...
2. Configure Cumulative Total parameters
Result
After you have completed the wizard screens according to the process above and clicked Finish, you return to the Visual Composer workspace, where a new data service has been created with the query you have configured.
A data service created with the BI Query Wizard is configured automatically with a start input and a table view as output. These three elements together constitute a complete iView, ready for preview and deployment to your portal.
To continue working with your data service and query, see:
Example
For an example of working with the Cumulative Total template, see Configuring Cumulative Total Parameters.