Set Number format on Values from SQL Server

[hamish]

I am using the RadPivotGrid with a SQL Server Analysis server (2014) and all appears to work as expected. However one issue I noticed is that any fields I select to appear as "values" - i.e. the 'facts' - I do not get the option to set the number format. For example when I select a field from a PivotFieldList that is bound to a collection I get the options Sum, Count, Average, Number format etc when I click on the down arrow of any fields in the "Values" section of the field List,

However when I select a field from a field list that uses a SQL Server Analysis Cube as the data source I only get the options Index, % of Grand Total, More Calculations and clear calculations. There is no option to set the number format - how do I achieve this?  - thanks

[Rosen Vladimirov]

Hello Hamish,

When the data is from OLAP Cube, it is expected to be formatted in the correct way, that's why RadPivotGrid doesn't have built-in functionality to set the number format for this scenario. However you can use CellTemplate in order to achieve this. I've prepared a sample project to demonstrate this approach. Please give it a try and inform us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik