negative values and generally symbols in pivotgrid

[pkopsidas]

Hello i started using pivotgrid for a project but i don't seem to find how to pass negative values in the cells or symbols like ($, €). Can anyone help me cause it is a bit tricky to use but has features i want

[jarry]

Please define a 'formatter' function for the value fields to custom the value format.

Code:

pivot:{
    rows:['Country','Category'],
    columns:['Color'],
    values:[
        {field:'Price',op:'sum'},
        {field:'Discount',op:'sum',
            formatter:function(value,row){
                return '$'+value;
            }
        }
    ]
}