JavaScript
const spread = new GC.Spread.Sheets.Workbook(document.getElementById('spreadContainer'), { sheetCount: 2 });
const dataSheet = spread.getSheet(0);
const pivotSheet = spread.getSheet(1);
dataSheet.name('데이터');
pivotSheet.name('드릴다운');
const salesData = [
['지역', '제품', '분기', '매출액'],
['서울', '스프레드시트', 'Q1', 15000000],
['서울', 'PDF뷰어', 'Q1', 8000000],
['서울', '스프레드시트', 'Q2', 18000000],
['서울', 'PDF뷰어', 'Q2', 9500000],
['부산', '스프레드시트', 'Q1', 12000000],
['부산', 'PDF뷰어', 'Q1', 6000000],
['부산', '스프레드시트', 'Q2', 13000000],
['부산', 'PDF뷰어', 'Q2', 7000000],
['대구', '스프레드시트', 'Q1', 9000000],
['대구', 'PDF뷰어', 'Q1', 4500000],
['대구', '스프레드시트', 'Q2', 10500000],
['대구', 'PDF뷰어', 'Q2', 5200000],
];
dataSheet.setArray(0, 0, salesData);
dataSheet.tables.add('salesTable3', 0, 0, salesData.length, 4);
spread.setActiveSheet('드릴다운');
const pivotTable = pivotSheet.pivotTables.add(
'drillPivot', 'salesTable3', 1, 1,
GC.Spread.Pivot.PivotTableLayoutType.compact,
GC.Spread.Pivot.PivotTableThemes.medium2
);
pivotTable.suspendLayout();
pivotTable.options.showRowHeader = true;
pivotTable.options.showColumnHeader = true;
// 계층 행 필드: 지역 > 제품 (2단계 드릴다운)
pivotTable.add('지역', '지역', GC.Spread.Pivot.PivotTableFieldType.rowField);
pivotTable.add('제품', '제품', GC.Spread.Pivot.PivotTableFieldType.rowField);
pivotTable.add('분기', '분기', GC.Spread.Pivot.PivotTableFieldType.columnField);
pivotTable.add('매출액', '합계 (매출액)', GC.Spread.Pivot.PivotTableFieldType.valueField, GC.Pivot.SubtotalType.sum);
pivotTable.resumeLayout();
pivotTable.autoFitColumn();
document.getElementById('btnCollapseSeoul')?.addEventListener('click', () => {
pivotTable.collapse('지역', '서울', true);
});
document.getElementById('btnExpandSeoul')?.addEventListener('click', () => {
pivotTable.collapse('지역', '서울', false);
});
document.getElementById('btnCollapseBusan')?.addEventListener('click', () => {
pivotTable.collapse('지역', '부산', true);
});
document.getElementById('btnExpandBusan')?.addEventListener('click', () => {
pivotTable.collapse('지역', '부산', false);
});