Excel.TopBottomSelectionType enum

A simple enum for top/bottom filters to select whether to filter by the top N or bottom N percent, number, or sum of values.

Remarks

[ API set: ExcelApi 1.12 ]

Fields

items = "Items"

Filter the top/bottom N number of items as measured by the chosen value.

percent = "Percent"

Filter the top/bottom N percent of items as measured by the chosen value.

sum = "Sum"

Filter the top/bottom N sum as measured by the chosen value.