private DataTable CreateSummaryTable(ASPxPivotGrid pivotGrid, PivotGridField sourceField, PivotGridField targetField, PivotGridField valueField, object sourceFieldValue)
{
PivotSummaryDataSource ds = ASPxPivotGrid1.CreateSummaryDataSource();
DataTable dt = new DataTable();
dt.Columns.Add("SourceField", typeof(string));
dt.Columns.Add("TargetField", typeof(string));
dt.Columns.Add("Value", typeof(decimal));
for (int i = 0; i < ds.RowCount; i++)
{
if (ds.GetValue(i, sourceField) == sourceFieldValue)
{
dt.Rows.Add(new object[] { ds.GetValue(i, sourceField), ds.GetValue(i, targetField), ds.GetValue(i, valueField) });
}
}
return(dt);
}