React pivot table column calculated (balance).

[JORGE V]

Hi,

   In pivot table, I have the following table :

   

                          date 1           date 2        date 3     ....             

   initial_value     $100           ???            ???

   movement 1     $200           $50 

   movement 3     -$100          -$100   

   grand total        $200           

  

   I would like to do that the value for initial column date 2 (and date 3, etc) would be equal to grand total column left.

   For column date2 the value would be: $200.

   For column date3 the value would be: $150.   

   It's a calculated value (it is a balance).

   * for movement "initial value" of column j =>   value !=0 ? initial_value: grand total of column (j-1).

   

   Is there any way to do this calculation ?. 

   I see examples of fields calculated in the documentation but differing from my needs.

   

Thanks in advance.

Jorge   

[Saranya Sivan]

Hi JORGE, 

  

The reported requirement cannot be achieved directly but we suggest you to do the customization manually. It can be achieved by using enginePopulated event where you can modify the cell value based on your conditions.  

UG: https://ej2.syncfusion.com/react/documentation/pivotview/data-binding/#enginepopulated 

  

Meanwhile, we have prepared a sample for your reference which is available in the below link. 

  

Sample:  https://stackblitz.com/edit/react-j2oydw-sqjklu?file=index.js 

  

Please let us know if you have concerns. 

  

Regards, 

Saranya S. 

 

[JORGE V]

Hi Saranya Sivan

In the enginePopulated event  I modified the values of args.pivotValues.

It seems Ok, thank you.

Jorge

[Saranya Sivan]

Hi Jorge, 

  

Thanks for the reply. 

  

Please let us know if you have any other queries. We are always happy to assist you.  

  

Regards, 

  

Saranya S.