Number Formatting in Ej2 Pivotgrid

[Bhavesh Patil]

Hi,

i have a pivotgrid where i want to display number with group separator with 2 numbers. For example: I want display the number in these format like 12,82,500.50. So can you please tell me how to do these. I have use format:'n2'.

[Jagadeesan Pichaimuthu]

Hi Bhavesh, 

  

You can format value fields using formatSettings. Please refer following code snippet. 

  

Code Snippet: 

var pivotGridObj = new ej.pivotview.PivotView({ 

    dataSource: { 

        values: [{ name: 'Sold', caption: 'Units Sold' }, { name:'Amount', caption: 'Sold Amount' }], 

        formatSettings: [{ name: 'Amount', format: 'N2' }], 

    } 

}); 

pivotGridObj.appendTo('#PivotView'); 

  

  

Sample: https://stackblitz.com/edit/19vxvw?file=index.js 

  

Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/how-to/customize-number-date-and-time-values/#number-formatting 

https://ej2.syncfusion.com/javascript/documentation/common/internationalization/?no-cache=1#manipulating-numbers 

  

Please let us know if you need further assistance on this. 

  

Regards, 

Jagadeesan 

[Bhavesh Patil]

With just using format n2 is not heIpfull. I want display the number Grouping in these format like 12,82,500.50.

[Manikandan Murugesan]

Hi Bhavesh, 

 

Currently, we are analyzing your requirement. And, we will update you the details on 17^th June 2019.  

Regards, 

Manikandan. 

[Manikandan Murugesan]

Hi Bhavesh, 

  

Thanks for the patience. 

 

You can achieve your requirement by loading ‘cldr-data’ (en-IN) using AJAX. Please refer following code snippet. 

 

Code Snippet: 

<script> 

    var pivotGridObj = new ej.pivotview.PivotView({ 

        dataSource: { 

            data: pivotData, 

            expandAll: false, 

            columns: [{ name: 'Year', caption: 'Production Year' }, { name: 'Quarter' }], 

            values: [{ name: 'Sold', caption: 'Units Sold' }, { name: 'Amount', caption: 'Sold Amount' }], 

            rows: [{ name: 'Country' }, { name: 'Products' }], 

            formatSettings: [{ name: 'Amount', format: 'N2' }], 

            filters: [] 

        } 

    }); 

    pivotGridObj.appendTo('#PivotGrid'); 

 

    function loadCultureFiles(name) { 

        var files = ['ca-gregorian.json', 'numbers.json', 'timeZoneNames.json', 'currencies.json']; 

        var loadCulture = function (prop) { 

            var val, ajax; 

            ajax = new ej.base.Ajax(location.origin + '/../../scripts/cldr-data/main/' + name + '/' + files[prop], 'GET', false); 

            ajax.onSuccess = function (value) { 

                val = value; 

            }; 

            ajax.send(); 

            ej.base.loadCldr(JSON.parse(val)); 

            ej.base.setCulture('en-IN'); 

            ej.base.setCurrencyCode('INR'); 

        }; 

        for (var prop = 0; prop < files.length; prop++) { 

            loadCulture(prop); 

        } 

    } 

 

    document.addEventListener('DOMContentLoaded', function () { 

        loadCultureFiles('en-IN'); 

    }); 

 

</script> 

 

Sample: http://www.syncfusion.com/downloads/support/forum/145204/ze/MVC-566168746 

Document: https://ej2.syncfusion.com/javascript/documentation/pivotview/globalization-and-localization/#internationalization 

Please let us know if you need further assistance on this. 

 

Regards, 

Manikandan.