Filter

In the tab “Data” it is possible to create a quick filter for the whole pivot. It could be done in two ways:

Way 1. Click “Edit Filter” button in “Data” tab in dashboard design window.

Way 2. Open context menu (click the right mouse button) at any place of a pivot.

Only those hierarchies, which are present in the report, may be a filter for a Pivot:

Let us display, for instance, values “Reseller Sales Amount” and “Reseller Gross Profit” for product categories “Bikes” and “Clothing”:

Pivot will look the following: