Summaries based on other column

Question

Example:We have two columns Currency and Value.EUR 1200EUR 1000CHF 200I want add two rows on summary:Sum EUR 2200Sum CHF 200Normal double sum but calculate rows with value in other column.Any ideas ?Grouping on Currency is not accepted by users.

Krzysztof Adamowicz · Answer

I did it using new class base on SummaryBase.

I was inspired by example on forum Weightedsummaries

Column descriptor is combination column name, column with currency, summarized currency

Maybe somebody knows better solution

Mohanraj Gunasekaran · Answer

Hi Krzysztof, 

By default, GridGroupingControl does not have the direct support to add summaries based on the other columns. But you can achieve your scenario by using SummaryType.Custom summary preoprty and QueryCustomSummary event. In attached sample, we have used two separate methods (CreateEurSummaryMethod and CreateChrSummaryMethod) in SummaryBase class which is the recommended way to achieve your scenario. 

Code example 




this.gridGroupingControl1.QueryCustomSummary += new GridQueryCustomSummaryEventHandler(gridGroupingControl1_QueryCustomSummary); 
 
GridSummaryColumnDescriptor sd0 = new GridSummaryColumnDescriptor(); 
sd0.Name = "EURTotal"; 
sd0.DataMember = "Amount"; 
sd0.DisplayColumn = "Amount"; 
sd0.Format = "EUR:{Total}"; 
sd0.SummaryType = SummaryType.Custom; 
this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 0", "Total", sd0)); 
             
 
GridSummaryColumnDescriptor sd1 = new GridSummaryColumnDescriptor(); 
sd1.Name = "CHRTotal"; 
sd1.DataMember = "Amount"; 
sd1.DisplayColumn = "Amount"; 
sd1.Format = "CHR:{Total}"; 
sd1.SummaryType = SummaryType.Custom; 
this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 1", "Total", sd1)); 
 
private void gridGroupingControl1_QueryCustomSummary(object sender, GridQueryCustomSummaryEventArgs e) 
{ 
    switch (e.SummaryColumn.Name) 
    { 
        case "EURTotal": 
            { 
                e.SummaryDescriptor.CreateSummaryMethod = new CreateSummaryDelegate(TotalSummary.CreateEurSummaryMethod); 
                break; 
            } 
        case "CHRTotal": 
            { 
                e.SummaryDescriptor.CreateSummaryMethod = new CreateSummaryDelegate(TotalSummary.CreateChrSummaryMethod); 
                break; 
            } 
    } 
} 
 
Screenshot 
  
 
Sample link: GridGroupingControl 
 
Please refer the below UG and KB links, 
 
UG link: https://help.syncfusion.com/windowsforms/gridgrouping/summaries#custom-summaries  
KB links: https://www.syncfusion.com/kb/6684/how-to-create-custom-summary-at-run-time  
                https://www.syncfusion.com/kb/700/how-to-calculate-summaries-for-both-minimum-and-maximum-values-of-the-date-field  

Please let us know if you have any other concerns. 

Regards, 
Mohanraj G

Krzysztof Adamowicz · Answer

Looks fine

Mohanraj Gunasekaran · Answer

Hi Krzysztof, 
 
Thanks for your update. 
 
We are glad to know that your reported problem has resolved. 
 
Please let us know if you have any concerns. 
 
Regards, 
Mohanraj G