I have a pivotGrid & a dropdown box with some numeric values(0,1,2) for setting decimal places for a column(e.g. Cost). when i select any value and set the values (2 decimal points) as below. But grid is not reflecting any change. it still shows default format with 4 decimal places. Please let me know what am i doing wrong?

private void OnADecimalSelectionComboBoxChanged(object sender, SelectionChangedEventArgs e){

if (this.DecimalSelectionComboBox == null) return;

DimensionMetadata dimData = new DimensionMetadata();

dimData.DisplayFormat = "{0:0.00}";

dimData.SourcePropertyName = "Cost";

FlatDataSource fds = (FlatDataSource)this.pivotGrid.DataSource;

fds.CubesSettings[0].DimensionSettings.Add(dimData);

this.pivotGrid.DataSource.RefreshGrid();

}