ExcelScript.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.

Fields

items

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

percent

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

sum

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