[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

ST_DynamicFilterType (Dynamic Filter)

These are the dynamic filter types. A dynamic filter returns a result set which may vary due to a change in the data itself or a change in the date on which the filter is being applied. For example, for a set of data {1,1,2,3}, the aboveAverage filter would return or highlight the last two values in the set. If the data is refreshed or changed to {1,1,1,2}, then only the last value would be highlighted. Similarly, the meaning of "lastQuarter" shall be the same for the dates in January, February, and March, but shall change meaning once the date advances from March to April.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

aboveAverage (Above Average)

Shows values that are above average.

belowAverage (Below Average)

Shows values that are below average.

lastMonth (Last Month)

Shows last month's dates.

lastQuarter (Last Quarter)

Shows last quarter's dates.

lastWeek (Last Week)

Shows last week's dates.

lastYear (Last Year)

Shows last year's dates.

M1 (1st Month)

Shows the dates that are in January, regardless of year.

M10 (10th Month)

Shows the dates that are in October, regardless of year.

M11 (11th Month)

Shows the dates that are in November, regardless of year.

M12 (12th Month)

Shows the dates that are in December, regardless of year.

M2 (2nd Month)

Shows the dates that are in Februray, regardless of year.

M3 (3rd Month)

Shows the dates that are in March, regardless of year.

M4 (4th Month)

Shows the dates that are in April, regardless of year.

M5 (5th Month)

Shows the dates that are in May, regardless of year.

M6 (6th Month)

Shows the dates that are in June, regardless of year.

M7 (7th Month)

Shows the dates that are in July, regardless of year.

M8 (8th Month)

Shows the dates that are in August, regardless of year.

M9 (9th Month)

Shows the dates that are in September, regardless of year.

nextMonth (Next Month)

Shows next month's dates.

nextQuarter (Next Quarter)

Shows next quarter's dates.

nextWeek (Next Week)

Shows next week's dates.

nextYear (Next Year)

Shows next year's dates.

null (Null)

Common filter type not available.

Q1 (1st Quarter)

Shows the dates that are in the 1st quarter, regardless of year.

Q2 (2nd Quarter)

Shows the dates that are in the 2nd quarter, regardless of year.

Q3 (3rd Quarter)

Shows the dates that are in the 3rd quarter, regardless of year.

Q4 (4th Quarter)

Shows the dates that are in the 4th quarter, regardless of year.

thisMonth (This Month)

Shows this month's dates.

thisQuarter (This Quarter)

Shows this quarter's dates.

thisWeek (This Week)

Shows this week's dates.

thisYear (This Year)

Shows this year's dates.

today (Today)

Shows today's dates.

tomorrow (Tomorrow)

Shows tomorrow's dates.

yearToDate (Year To Date)

Shows the dates between the beginning of the year and today, inclusive.

yesterday (Yesterday)

Shows yesterday's dates.

 

Referenced By

dynamicFilter@type3.3.2.5)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_DynamicFilterType">

   <restriction base="xsd:string">

   <enumeration value="null"/>

   <enumeration value="aboveAverage"/>

   <enumeration value="belowAverage"/>

   <enumeration value="tomorrow"/>

   <enumeration value="today"/>

   <enumeration value="yesterday"/>

   <enumeration value="nextWeek"/>

   <enumeration value="thisWeek"/>

   <enumeration value="lastWeek"/>

   <enumeration value="nextMonth"/>

   <enumeration value="thisMonth"/>

   <enumeration value="lastMonth"/>

   <enumeration value="nextQuarter"/>

   <enumeration value="thisQuarter"/>

   <enumeration value="lastQuarter"/>

   <enumeration value="nextYear"/>

   <enumeration value="thisYear"/>

   <enumeration value="lastYear"/>

   <enumeration value="yearToDate"/>

   <enumeration value="Q1"/>

   <enumeration value="Q2"/>

   <enumeration value="Q3"/>

   <enumeration value="Q4"/>

   <enumeration value="M1"/>

   <enumeration value="M2"/>

   <enumeration value="M3"/>

   <enumeration value="M4"/>

   <enumeration value="M5"/>

   <enumeration value="M6"/>

   <enumeration value="M7"/>

   <enumeration value="M8"/>

   <enumeration value="M9"/>

   <enumeration value="M10"/>

   <enumeration value="M11"/>

   <enumeration value="M12"/>

   </restriction>

</simpleType>