ClosedXML Pivot Table SetCalculation

Question

I am trying to use ClosedXML to export data with a pivot table. I am able to create the pivot table with the following code, but the SetCalculation is giving me some trouble. I am wanting to take the difference between the Amount column for each year. The Excel worksheet is unable to load and crashes all of Excel.

var pt = worksheet.PivotTables.AddNew("PivotTable", worksheet.Cell(rowIndex+3, 1), table.AsRange());

pt.ReportFilters.Add("Department");
pt.ReportFilters.Add("Month");
pt.ColumnLabels.Add("Year").SetCollapsed();
pt.RowLabels.Add("Account").SetCollapsed();
pt.RowLabels.Add("Description").SetCollapsed();
pt.Values.Add("Amount", "Amount").NumberFormat.NumberFormatId = 4;
pt.Values.Add("Diff","Diff").SetBaseField("Year").
SetBaseItem("Amount").SetCalculation
(XLPivotCalculation.DifferenceFrom).NumberFormat.NumberFormatId = 4;

Answer 1

I figured it out:

pt.Values.Add("Amount","Diff%").SetCalculation(XLPivotCalculation.PercentageDifferenceFrom).SetBaseField("Year").SetCalculationItem(XLPivotCalculationItem.Previous).NumberFormat.NumberFormatId = 10;