How to add Multiple Table/Group Summaries with Calculated Columns?

Question

Ok, so given the screenshot. Is there any way to achieve this with SfDataGrid on WPF? There are two or more table/group summaries here. In this example, I only provided rows for "Present" and "Absent" summaries. In this example, the first row seems pretty straight forward with "{Sum}" on each column, but how to place the labels "Present/Absent"... that is something I don't know, yet. Now, on the 2nd row... which has all the absent summary, these are mostly calculated values based on SUM of all members minus or less the values from the present row. So, how do you put labels such as the "Present" and "Absent" without using ShowSummaryInRow=True, AND most importantly how do you add summaries with calculated values? How would you do it in SfDataGrid, with the same result show in the screenshot?

Please advise. Thanks!

Arulpriya Ramalingam · Answer

Hi Domingo,

Thank you for your interest in Syncfusion products.

Query : but how to place the labels "Present/Absent"... that is something I don't know,

This can be added by using the Title property of the GridSummaryRow. Please refer the below code example.

Example code

<syncfusion:GridSummaryRow ShowSummaryInRow="False" TitleColumnCount="3" Title="Present">

<syncfusion:GridSummaryRow.SummaryColumns>

<syncfusion:GridSummaryColumn Name="SUM_AS" MappingName="WBCB_AS"

SummaryType="{Count}" />

</syncfusion:GridSummaryRow>

Query: Now, on the 2nd row... which has all the absent summary, these are mostly calculated values based on SUM of all members minus or less the values from the present row. So, how do you put labels such as the "Present" and "Absent" without using ShowSummaryInRow=True, AND most importantly how do you add summaries with calculated values?

This can be achieved by adding a custom summary for the specified function and we already provided the details to create custom summaries in our user guide. Please make use of the below UG for further details.

UG link: https://help.syncfusion.com/wpf/datagrid/summaries#custom-summaries

Please get back to us if you need any further assistance.

Regards,

Arulpriya Ramalingam.