thanks

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 Kokkalagadda
Associate Software Developer

Why no replies to these clarifications

Regards,

Jims