In this walk through you will create a calculated summary in a WinGrid™ column footer using a formula. The summary will show a grand total of the "Item Total" column in the grid. This walk through builds off the Creating a Calculated Column in WinGrid and Using WinCalcManager to Create Running Totals in WinGrid topics.
Add summary information to the grid column footers.
Right-click the WinGrid and select "UltraGrid Designer" to launch the grid designer.
In the grid designer, drill down to the node: "Band and Column Settings> Band[0] - 'Order Details'."
In the properties grid on the right scroll down to where the Summaries collection is located.
Click the ellipse to open up the SummarySettings collection editor. With the editor open click the add Button to add a new SummarySettings.
Set in the properties grid on the SummarySettings the SummaryPosition to Right and the Formula property to the following formula.
sum ( [ItemTotal] )
Now run the project again to view the result: the column footer is filled with the result of the calculation.
This walk through was designed to show you how to add a Calculated Summary in a WinGrid Column footer using the WinCalcManager.