//очищаю
            pivotGridControl1.ItemSource = null;
            pivotGridControl1.PivotRows.Clear();
            pivotGridControl1.PivotColumns.Clear();
            pivotGridControl1.PivotCalculations.Clear();            
            pivotGridControl1.TableControl.AllowColumnResizeUsingCellBoundaries = true;
            pivotGridControl1.ShowGroupBar = true;
            pivotGridControl1.AllowFiltering = true;
            pivotGridControl1.AllowSorting = true;
            pivotGridControl1.ShowGrandTotals = false;
            pivotGridControl1.ShowGrandTotals = true;
//формирую запрос к базе
            SqlCommand comm1 = new SqlCommand("select * from fn_selection(@StartDateTime, @EndDateTime)", conn1);
            comm1.Parameters.AddWithValue("@StartDateTime", dateTimePicker1.Value);
            comm1.Parameters.AddWithValue("@EndDateTime", dateTimePicker2.Value);
            comm1.CommandTimeout = 60;
            try
            {
                conn1.Open();
            }
            catch (Exception xx)
            {            }
            SqlDataAdapter da1 = new SqlDataAdapter(comm1);
            DataSet ds = new DataSet();

            da1.Fill(ds, "TableMeat");
         

//подключаю
            BindingSource b2 = new BindingSource { DataSource = ds.Tables["Table1"] };      
            pivotGridControl1.ItemSource = b2;
//отображаю данные по строкам
            pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "DateJob" });
            pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "Naim" });
//и столбцам
            pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "DayNight" });
            pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "PlanFact" });
//после суммирую
 pivotGridControl1.PivotCalculations.Add(  new PivotComputationInfo { FieldName = "Planned", Format = "0.00", SummaryType = Syncfusion.PivotAnalysis.Base.SummaryType.DoubleTotalSum, FieldHeader = "Planned" });