Cascading User Filters


Zoho Reports now allows you to set up cascading user filters i.e., the list of values available in one User Filter depends on the value that you have chosen in the preceding User Filter(s). This feature ensures that you only select valid filter values at any time. It also reduces the time taken to scroll through a long list of filter values to select from.

For example, let's say you have one user filter to filter Product Category , and a second filter to filter Products in a report. If you select Furniture in the Product Category filter, only the products which comes under the category Furniture will be listed in the drop down list of the Products filter, instead of listing all the products.

To set cascading behavior for a user filter, while creating it, in the Choose Value tab of user filter settings dialog box, select the value List only relevant values for the option Behavior when user filters are applied