PivotGridControl에 데이터 할당하기

public void pivotgrid_setting()
        {
						// PivotGridControl pgclist = new PivotGridControl();
            pgcList.BeginUpdate();

            pgcList.DataSource = pivotgrid_getdata();

            // 행으로 나타낼 필드
            PivotGridField fieldPV_CODE = new PivotGridField()
            {
                Area = PivotArea.RowArea,
                AreaIndex = 0,
                FieldName = "PV_CODE",
                Caption = "장비코드",
            };

            // 열로 나타낼 필드
            PivotGridField fieldPV_DATE = new PivotGridField()
            {
                Area = PivotArea.ColumnArea,
                AreaIndex = 0,
                FieldName = "PV_DATE",
                Caption = "생산일자",
            };

            PivotGridField fieldPV_QTY = new PivotGridField()
            {
                Area = PivotArea.DataArea,
                AreaIndex = 0,
                FieldName = "PV_QTY",
                Caption = "불량수량",
            };
            fieldPV_QTY.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
            fieldPV_QTY.CellFormat.FormatString = "n0";

            // 위에서 정의한 필드로 피벗 구성
            pgcList.Fields.Clear();
            pgcList.Fields.AddRange(new PivotGridField[]
            {
                                        fieldPV_CODE,
                                        fieldPV_DATE,
                                        fieldPV_QTY
            });

            pgcList.EndUpdate();

            // 필터 항목을 설정하지 않았으므로 숨김
            pgcList.OptionsView.ShowFilterHeaders = false;
        }

데이터 테이블 형식

CREATE TABLE TEST_PIVOTGRIDCONTROL_DATA(
PV_CODE VARCHAR(100),
PV_DATE VARCHAR(8),
PV_QTY NUMERIC
)

INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('A100', '20220717', 4)
INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('A100', '20220718', 4)
INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('B300', '20220717', 2)
INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('B300', '20220718', 1)
INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('C500', '20220717', 3)
INSERT INTO TEST_PIVOTGRIDCONTROL_DATA (PV_CODE, PV_DATE, PV_QTY)
VALUES('C500', '20220718', 3)

실행후 PivotGridControl 모습