How to Summarizing Columns in PivotGrid

In some cases, you may want to display the sum of a column in the grand total, even if the default aggregation is set to a different function, such as MAX. This can be achieved using nested expressions in the PivotGrid.

Steps to Summarize a Column with Nested Expressions

1. Create the first expression with MAX aggregation to the field 4510 Booked Country, like this

   

2. Create a second expression by simply adding the first expression:

   

3. Bind the second expression to the PivotGrid to display the summarized column:

By following these steps, you can display the sum of a column in the grand total, even if the default aggregation is set to a different function.

Additional References

• PivotGrid Documentation
• Expression Fields in PivotGrid