Pls help me to remove dollar symbol from measure values.
Also give the idea to remove the (All columns - sub total) from displayed data.
Regards,
Jims
I mean remove 'All Items' when we expand the data.
Thanks,
Why no replies to these clarifications
Hello Jims,
Please clarify the DataSource that you are using for the PivotGrid. If you are using a FlatDataSource then there is a possibility to remove the dollar sign from measures by modifying the DisplayFormat property in the InitializeMeasureDescriptor event. You can refer to the attached sample on how to achieve this. For example, the DisplayFormat can be set to something like this:
void ds_InitializeMeasureDescriptor(object sender, InitializeMeasureDescriptorEventArgs e) { if (e.MeasureDescriptor.Name == "Budget") { e.MeasureDescriptor.DisplayFormat = "##.00"; e.MeasureDescriptor.Aggregation = MeasureAggregation.Average; } }
Also, AllMembers level can be removed only when it is a FlatDataSource and when FlatDataSource.GenerateCube method is used to create the cube. Once you clarify the DataSource I will further assist you with this issue.
Please let me know if you have any questions.
Sincerely,Sahaja KokkalagaddaAssociate Software Developer
thanks