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. Image for the cookie policy date

Pivot numeric format


I need format the values. I need show thousand separator but not decimals.

I try setting FormatString with this values

  • FormatString("n0")
  • FormatString("{0:n0}")

But it doesn't work.

I attach an example


Attachment: PivotFormat_7f6cc40b.zip

3 Replies

SP Sastha Prathap Selvamoorthy Syncfusion Team April 20, 2017 06:32 AM UTC

Hi Manolo, 
Currently we don’t have “formatstring” support to customize the decimal/number format in the PivotGrid. Meanwhile, the requirement is valid one so we have created an incident to log a feature report on behalf of you. Our support engineer will assist you through incident. We request you to follow with the incident for further details.
Sastha Prathap S. 

MA Manolo April 20, 2017 09:26 AM UTC


SP Sastha Prathap Selvamoorthy Syncfusion Team April 21, 2017 03:31 AM UTC

Hi Manolo, 
Thanks for the response.  
Please let us know if you need any further assistance. 
Sastha Prathap S. 

Live Chat Icon For mobile
Up arrow icon