Get selected rowinfo in pivot grid

Question

HiWe have a requirement where we are not enabling selection in pivot grid, but need to get the row info (grandtotal of the column) from the pivot grid on demand from .ts file based on rowindex only.How to achieve it ?Thanks,Dileep gagan R

Saranya Sivan · Accepted Answer

Hi Dileep, 
  
We have modified the sample to show the grand total based on the row index in the pivot table. Please find the sample for your reference.   
  
Sample: https://stackblitz.com/edit/angular-jwjmtg-acqqrb?file=app.component.html 
  
Code Snippet: 
  




displayGrandTotal(rowIndex) { 
    let pivotValues: any = this.pivotObj.pivotValues; 
    console.log(pivotValues[pivotValues.length - 1][rowIndex].value); 
  } 
  
Please let us know if you have concern. 
  
Regards, 
Saranya Sivan.

Saranya Sivan · Answer

Hi Dileep, 
  
Based on your requirement we have prepared a sample to get row info (grand total of the column) of the pivot table. Please check the below sample and code snippet for your reference. 
  
Sample Link: https://stackblitz.com/edit/angular-jwjmtg-dif48m?file=app.component.html 
  
Code Snippet: 
  




document.getElementById("rowInfo").onclick = () => { 
      let pivotValues: any = this.pivotObj.pivotValues; 
      console.log(pivotValues[pivotValues.length - 1]); 
    }; 
  
We hope the above sample meets your requirements. Please let us know if you have concern. 
  
Regards, 
Saranya Sivan.

Dileep gagan R · Answer

Hi Dileep, 
  
Based on your requirement we have prepared a sample to get row info (grand total of the column) of the pivot table. Please check the below sample and code snippet for your reference. 
  
Sample Link: https://stackblitz.com/edit/angular-jwjmtg-dif48m?file=app.component.html 
  
Code Snippet: 
  




document.getElementById("rowInfo").onclick = () => { 
      let pivotValues: any = this.pivotObj.pivotValues; 
      console.log(pivotValues[pivotValues.length - 1]); 
    }; 
  
We hope the above sample meets your requirements. Please let us know if you have concern. 
  
Regards, 
Saranya Sivan. 
 
 Hi,Thanks for the response, we are looking for single row at a time, passing rowindex or colindex and getting the grandtotal of the row. In the example provided we will get grandtotal of all the rows. we require based on rowindex or colindex. How to achieve this?Thanks,Dileep gagan R