How to Display Cumulative Values in Pivot Grid Using Expressions

In many scenarios, you may need to display cumulative values in a Pivot Grid. This can be achieved by using expressions. The process involves creating an expression using the RUNNINGSUM function and binding that expression to a column in the Pivot Grid.

Steps to Display Cumulative Values

1. Create an expression using the RUNNINGSUM function. For example, you can save the expression RUNNINGSUM(SUM("Value")). This expression will calculate the running sum of the “Value” field.

2. Bind the created expression to a column in the pivot Grid. This will allow the pivot grid to display the results
   

   
   
   
   
   
   By following these steps, you can successfully display cumulative values in a Pivot Grid using expressions.

References

• RUNNINGSUM Function
• Pivot Grid