Class PivotTableAdvancedFilter
Represents a PivotTable advanced filter.
Inheritance
System.Object
PivotTableAdvancedFilter
Assembly: DRIT.Spreadsheet.dll
Syntax
public class PivotTableAdvancedFilter : object
Properties
AutoFilter
Declaration
public AutoFilter AutoFilter { get; }
Property Value
Description
Gets the description of the pivot filter.
Declaration
public string Description { get; }
Property Value
| Type |
Description |
| System.String |
|
EvaluationOrder
Gets the evaluation order of the pivot filter. Zero based.
Declaration
public int EvaluationOrder { get; }
Property Value
| Type |
Description |
| System.Int32 |
|
FieldIndex
Gets the index of the field to which this pivot filter belongs.
Declaration
public int FieldIndex { get; }
Property Value
| Type |
Description |
| System.Int32 |
|
FilterType
Declaration
public PivotFilterType FilterType { get; }
Property Value
MeasureFieldIndex
Gets the index of the measure field. This property is used only by filters in Relational pivots and specifies on which measure a value filter should apply.
Declaration
public int? MeasureFieldIndex { get; }
Property Value
| Type |
Description |
| System.Nullable<System.Int32> |
|
MeasureIndex
Gets the index of the measure cube field. This property is used only by filters in OLAP pivots and specifies on which measure a value filter should apply.
Declaration
public int? MeasureIndex { get; }
Property Value
| Type |
Description |
| System.Nullable<System.Int32> |
|
MemberPropertyFieldId
Gets the index of the field representing the member property field on which this pivot filter is defined. This property is used only by label pivot filters.
Declaration
public int? MemberPropertyFieldId { get; }
Property Value
| Type |
Description |
| System.Nullable<System.Int32> |
|
Name
Gets the name of the pivot filter.
Declaration
public string Name { get; }
Property Value
| Type |
Description |
| System.String |
|
StringValue1
Gets the string value "1" used by label pivot filters.
Declaration
public string StringValue1 { get; }
Property Value
| Type |
Description |
| System.String |
|
StringValue2
Gets the string value "2" used by label pivot filters.
Declaration
public string StringValue2 { get; }
Property Value
| Type |
Description |
| System.String |
|