EnumDynamicFilterType
Specifies the criterion type for DynamicFilter, including relative date periods, specific months/quarters, and average comparisons.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.Filtering
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public enum DynamicFilterTypeFields
AboveAverage
Shows rows with numeric values greater than the column's average.
April
Shows rows with dates falling in April of any year.
August
Shows rows with dates falling in August of any year.
BelowAverage
Shows rows with numeric values less than the column's average.
December
Shows rows with dates falling in December of any year.
February
Shows rows with dates falling in February of any year.
January
Shows rows with dates falling in January of any year.
July
Shows rows with dates falling in July of any year.
June
Shows rows with dates falling in June of any year.
LastMonth
Shows rows with dates falling in last calendar month.
LastQuarter
Shows rows with dates falling in last fiscal quarter.
LastWeek
Shows rows with dates falling in last week (7 days prior to current week).
LastYear
Shows rows with dates falling in last calendar year.
March
Shows rows with dates falling in March of any year.
May
Shows rows with dates falling in May of any year.
NextMonth
Shows rows with dates falling in next calendar month.
NextQuarter
Shows rows with dates falling in next fiscal quarter (Q1: Jan-Mar, Q2: Apr-Jun, Q3: Jul-Sep, Q4: Oct-Dec).
NextWeek
Shows rows with dates falling in next week (7 days ahead of current week).
NextYear
Shows rows with dates falling in next calendar year.
None
No filter applied; all rows pass.
November
Shows rows with dates falling in November of any year.
October
Shows rows with dates falling in October of any year.
Quarter1
Shows rows with dates falling in the first fiscal quarter (January through March).
Quarter2
Shows rows with dates falling in the second fiscal quarter (April through June).
Quarter3
Shows rows with dates falling in the third fiscal quarter (July through September).
Quarter4
Shows rows with dates falling in the fourth fiscal quarter (October through December).
September
Shows rows with dates falling in September of any year.
ThisMonth
Shows rows with dates falling in the current calendar month.
ThisQuarter
Shows rows with dates falling in the current fiscal quarter.
ThisWeek
Shows rows with dates falling in the current week (Sunday through Saturday containing today).
ThisYear
Shows rows with dates falling in the current calendar year.
Today
Shows rows with dates matching today's date (relative to execution time).
Tomorrow
Shows rows with dates matching tomorrow's date (relative to execution time).
YearToDate
Shows rows with dates from January 1st of the current year through today.
Yesterday
Shows rows with dates matching yesterday's date (relative to execution time).