We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to group data and calculate sum with a formula

Thread ID:

Created:

Updated:

Platform:

Replies:

132702 Sep 15,2017 04:48 PM Sep 19,2017 08:15 AM Angular 3
loading
Tags: ejGrid
Kam Lo
Asked On September 15, 2017 04:48 PM

An example dataset looks like this:

{'Amazon', 'productABC', '1.23', '8'}
{'Walmart', 'productCDE', '100', '2'}
{'Amazon', 'thing1', '200', '2'}
{'Walmart', 'thing2', '100', '2'}
{'twinings', 'thing3', '80', '5'}

Trying to group by the first column, and calculate a 5th column with numbers in the 3rd and 4th column. 
the example outcome for Amazon will be
{'Amazon', blank, '201.23', '10', '20.123'}   

Notice the last column is calculated with a formula from grouping by first column. 



Mani Sankar Durai [Syncfusion]
Replied On September 18, 2017 06:53 AM

Hi Kam, 

Thanks for contacting Syncfusion support. 

We have analyzed your query and we have prepared a sample based on your requirement that can be downloaded from the below link. 
In this sample we have enable grouping for the column 1 and set the summary value based on the first column. Also we have displayed the sum of the 3rd and 4th column in the 5th column using template property of columns in grid.  
Refer the code example 
[index.html] 
  <script id="columnTemplate" type="text/template"> 
        <span>{{:Freight + ID }}</span> 
    </script> 
 
[app.component.ts] 
export class AppComponent { 
 
    public groupSettings = { groupedColumns: ["Order"] };  //set grouping for column 1 
    public summaryRows = [{ 
        summaryColumns: [{ summaryType: ej.Grid.SummaryType.Sum, displayColumn: "Freight", dataMember: "Freight", format: "{0:C2}", prefix: "Sum = " }, 
            { summaryType: ej.Grid.SummaryType.Sum, displayColumn: "ID", dataMember: "ID", prefix: "Sum = " }, 
         //set summary value for column 3 and 4 
    }]; 
    public columnTemplate = "#columnTemplate"; //assign template for the column 
... 
    
  @ViewChild('grid') Grid: EJComponents<any, any>; 
 
[app.component.html] 
<ej-grid #grid [dataSource]="gridData" [allowPaging]="true" [allowGrouping]="true" [showSummary]="true"  [groupSettings]="groupSettings" [summaryRows]="summaryRows"> 
     <e-columns> 
... 
        <e-column field="ID" headerText="ID" width="75" textAlign="right"></e-column> 
         <e-column field="Freight" headerText="Freight" width="75" format="{0:C}" textAlign="right"></e-column> 
          <e-column field="Sum" headerText="Sum" width="75"[template]="columnTemplate" textAlign="right"></e-column> 
             
    </e-columns>        
</ej-grid> 

Refer the documentation link. 
Link:  

If you need to set the summary value for the 5th column (i.e template column) it can be achieved using custom summary feature in grid.  
Refer the documentation link. 

Please let us know if you need further assistance. 

Regards, 
Manisankar Durai. 



Kam Lo
Replied On September 18, 2017 12:08 PM

 http://www.syncfusion.com/downloads/support/forum/132702/ze/ejGrid_exporting-1609824946 

cannot view this link. It's blocked. how are we suppose to view the example? Thank you. 


Mani Sankar Durai [Syncfusion]
Replied On September 19, 2017 08:15 AM

 Hi Kam,  
 
 
The give download link working fine for us, please check with your network team, may your network blocked our Syncfusion downloads.  
 
You can get file using FTP. Please find the FTP Credentials for accessing our server folder in below. Also, please refer the attached document to get the more details about this.   
   
Credentials:    
   
Host: www.syncfusion.com    
Username: Kamlo   
Password: rnaN9s-s   
   


 
Please follow below steps:  
 
  
 
Go to Edit-> Settings and ensure the below settings before connecting to the FTP.  
  1. FTP Transfer mode must be ‘Passive’.
  
   
  
  
  1. For active mode, enable the option as like in the screenshot.
  
  
   
  
  1. For passive mode, enable the option as like in the screenshot,
  
   
  
  1. Click ‘OK’ to save the settings
  2. If the Passive mode does not work. Please use the active mode to connect to the server.
  
   
 
 
Regards, 
Manisankar Durai. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;