Can anyone give me an example?
Hello Rogerio,
Thank you for contacting Infragistics!
I am currently researching to see how this may be possible. I am currently discussing this with my team. I will continue to look into this matter and will give you a progress update by the end of the day Wednesday.
Thank you for your patience. I am currently discussing this matter further with our development team. I will continue to look into this matter and will give you a progress update by the end of the day Monday.
That's it. Many thanks for the reply.
I am following up to see if the information provided has resolved this matter.
Please let me know if I may be of further assistance with this matter.
Thank you for your patience. I have done some further discussing with our development team and have found the following information. If you are using a flat data source, you can refer to the attached sample. Look into the “sum” function and you should be able to understand how to format the values.
If you are using XMLA as a data source, there is no built-in way of formatting the value. Creating such functionality should be a product idea.
You can suggest new product ideas for future versions (or vote for existing ones) on our UserVoice website: http://ideas.infragistics.com/
There is an easy workaround, which includes manipulating the DOM element’s text. The user just needs to bind to the “igpivotgridpivotgridrendered” event and use a function like the following:
function (evt, ui) { var cells = $("#pivotview").find(".ui-igpivotgrid td"); for (var i = 0; i < cells.length; i++) { cells.eq(i).text("{[(" + cells.eq(i).text() + ")]}"); } }