Skip to main content

Dragging and Dropping Filter Items

Dragging and Dropping Filter Items

You can drag and drop an individual member to use as a filter. To do so, drag and drop a member to Drop filter here in the Filters box or to the filter bar.

The pivot table is then filtered to show only data for that member. The Filters box displays the name of the associated level, and the filter bar displays the name of the level and the member. For example:

Filters box shows product category, label shows Snack as filter

FeedbackOpens in a new tab