Window Calculations
 6 minutes to read
Window calculations provide the capability to apply specific computations to measure values and allow you to perform different analytical tasks such as computing running totals, percentages of totals, differences, etc.
To create a window calculation, invoke the Binding menu and click the required measure. In the invoked data item menu, go to Calculations and select one of the available calculations.

After you have selected the required calculation, you can change its default settings by clicking the Edit button (the icon). This invokes the window containing common and specific calculation settings.
Note
The dashboard control does not allow sorting by measures with applied Window Calculations since the calculation value can depend on the calculated element position.
Percent of Total

In the Grid below, Percent of Total is applied to a fourth column to show a contribution of individual quarterly sales to total sales.
Running Summary

In the Grid below, the Running Total is applied to a fourth column to display cumulative sales across all quarters.
Difference

In the Grid below, the Difference is applied to a fourth column to show absolute differences between quarterly sales.
Percentage Difference

In the Grid below, Percentage Difference is applied to a fourth column to show percentage differences between quarterly sales.
Moving

In the Grid below, a Moving calculation is applied to a fourth column to show a moving average across all quarters.
Rank

In the Grid below, a Rank calculation is applied to a fourth column to show a ranking of sales for individual quarters.
Custom
