修改ASPxPivotGrid1的ShowColumnGrandTotals，显示我想要的数据算法非合计（例：平均）

来源：互联网发布：mac不知管理员名称密码编辑：程序博客网时间：2024/05/29 08:39

protected void ASPxPivotGrid1_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)
        {
                        string name = e.DataField.FieldName;
            if (e.ColumnValueType == DevExpress.XtraPivotGrid.PivotGridValueType.GrandTotal)
            {
                IList list = e.CreateDrillDownDataSource();
                for (int i = 0; i < list.Count; i++)
                {
                    DevExpress.XtraPivotGrid.PivotDrillDownDataRow row = list[i] as DevExpress.XtraPivotGrid.PivotDrillDownDataRow;

                    object v = row[name];
                    if (row["xh"].ToString() == "aa")
                    {
                            e.DisplayText = new BLL_JHFXReport().getHE("where").ToString();
                   }

                }
            }
        }