DROPDOWN_MANY

Creates a multi-value dropdown selector for a data field in a cell. Select multiple values from the dropdown popup. For single-value only selection, see DROPDOWN.

Function syntax

DROPDOWN_MANY(field | filter, ... | option, ... | selected, ...)

Arguments:

• field: The data field for the dropdown selector.
• filter, …: (optional) One or more data fields containing a filter value(s) that limit the values presented in the dropdown many selector. Filter values can reference cells, including cells with DROPDOWN selectors.

Returns

A constraint value for use in filters of other functions. Example: SUM(sales{brand{D1}}) where D1 contains =DROPDOWN_MANY(brand).

Examples

• DROPDOWN_MANY(brand) - Dropdown with all brand values.
• DROPDOWN_MANY(brand |promo{“yes”}) - Dropdown with all the brand values sold on promotion yes.