Changing the Display values of Cells from External Control

[Shreekumar]

Hi Team

I'm using PivotView and is there any way I can change the display values of each cell from external control?

For example:

I have a Dropdown and that contains  the following values:

a. N/A

b. 100

c. 1000

d. 10000

 If  I change the selected value. The pivot grid should re-load to display the values per the new precision.

If the value of cell is 7869 and the display precision is selected as 100, then the value in the cell will be displayed as 78.69 (<metric_value> / <display_precision>).

[Sivamathi Natarajan]

Hi ShreeKumar, 

 

Thanks for contacting Syncfusion support. 

 

 

We regret you to let you know that, based on the current architecture, the requirement couldn’t be achievable. Because we cannot modify the precision of existing fields. Instead you can create a new field where we use the existing field value and apply the precision using Calculated field. Meanwhile we have prepared a sample to update the requested formats using drop down list. Please refer the below sample for your reference. 

 

Here we have updated the precision of “Amount” field in the newly created field “Format”. 

Sample Link: https://stackblitz.com/edit/angular-ugad6c-yaw7oc?file=app.component.ts 

 

We hope the above sample meets your requirements. 

 

Regards, 

Sivamathi. 

[Shreekumar]

Hi Sivamathi

I mean to say, only Display values. In PivotView, we have 2 types of values (value & formatted-value)

For example: if Cell has a value 1900, display / formatted value can be 19.00 (assuming value of dropdown is 100)

[Sivamathi Natarajan]

Hi ShreeKumar, 

 

As we already mentioned in our previous update, the requirement couldn’t be achieved directly. And, calculated field feature is the only option to create a desired field based on the drop down changes.  

 

Regards, 

Sivamathi.