PivotTable.MissingItemsLimit
PivotTable.MissingItemsLimit property
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them.
public PivotMissingItemLimitType MissingItemsLimit { get; set; }
Examples
using System;
using Aspose.Cells;
using Aspose.Cells.Pivot;
namespace AsposeCellsExamples
{
public class PivotTablePropertyMissingItemsLimitDemo
{
public static void Run()
{
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
// Sample data
worksheet.Cells["A1"].Value = "Category";
worksheet.Cells["B1"].Value = "Value";
worksheet.Cells["A2"].Value = "A";
worksheet.Cells["B2"].Value = 10;
worksheet.Cells["A3"].Value = "B";
worksheet.Cells["B3"].Value = 20;
worksheet.Cells["A4"].Value = "C";
worksheet.Cells["B4"].Value = 30;
// Create pivot table and get the instance
int pivotIndex = worksheet.PivotTables.Add("PivotTable", "A1:B4", "E3");
PivotTable pivotTable = worksheet.PivotTables[pivotIndex];
// Configure pivot table
pivotTable.AddFieldToArea(PivotFieldType.Row, 0); // Category
pivotTable.AddFieldToArea(PivotFieldType.Data, 1); // Value
// Demonstrate MissingItemsLimit property
pivotTable.MissingItemsLimit = PivotMissingItemLimitType.Max;
// Refresh data
pivotTable.RefreshData();
pivotTable.CalculateData();
workbook.Save("PivotTableMissingItemsLimitDemo.xlsx");
}
}
}
See Also
- enum PivotMissingItemLimitType
- class PivotTable
- namespace Aspose.Cells.Pivot
- assembly Aspose.Cells