Autofilter on spreadsheet (on dynarange) - like Excel Autofilter

It would be great to add an Autofilter simular to Excel onto a spreadsheet (onto a dynarange).

Current situation:

All filters in a Jedox Web spreadsheet have to be implemented manually one by one via dropdowns, subsets etc.

This is great to reduce the amount of data already in the backend at first.

But it is very clumsy if you want to provide broader and flexible analytical power to the enduser on that report.

Example:

You generate a table with 20 columns and want to provide filters on all 20 columns to the enduser. (for flexibly analyzing the data)

Then you need to create 20 dropdowns, checkboxes, subsets or HIDEROW conditions etc. manually.

And you will especially have high effort, if that data comes from different cubes. (-> multiple DFilters etc.).

Target situation:

It would be great to apply a kind of Autofilter-Widget on top of a dynarange area. (purely frontend-side)

It could be an Autofilter simular to Excel or similar to table autofilters in several UI frameworks.

Basic functions:

- automatically sort by any column - by clicking on that column

- automatically filter rows in the dynarange area on any column automatically using a generic filter popup,

- filter by

-> text parts (e.g. all rows where column X has a value containing "abc")

-> numeric ranges (e.g. all rows where column Y is > 10, < 50, from 100 to 1000)

-> singleselect or multiselect of values in a column (e.g. select "New York", "Sidney", "Berlin" out of a list of citiees)

- give a combined result based on filters on multiple columns

(e.g. numeric filter on column 1 + textfilter on column 4 + multiselect filter on column 7)

Thanks a lot for checking/considering this feature request.

We can imagine, that this would be helpful for a lot of users and significantly enhance the analytical power of Jedox Web.