I have a chart bound to an ASPxPivotGrid. The data source is a SSAS cube. The grand totals appear in the chart. I thought the following code would turn them off but it doesn't.
ASPxPivotGrid1.OptionsChartDataSource.ShouldRemoveItem( true, PivotGridValueType.GrandTotal );
ASPxPivotGrid1.OptionsChartDataSource.ShouldRemoveItem( false, PivotGridValueType.GrandTotal );
Thank you for your report. PivotGridOptionsChartDataSourceBase.ShouldRemoveItem allows you to determine whether specific values should be hidden according to current settings. Please use the PivotGridOptionsChartDataSourceBase.ShowRowGrandTotals and PivotGridOptionsChartDataSourceBase.ShowColumnGrandTotals properties to control whether or not a grand total value should be charted.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.