filters on Sheets / List Boxes

[#1]

Dear colleagues,

I am working with a list of KPIs. The KPI's are divided into sections. I want to build a report that tells something about each section on a separate Sheet. All my KPI definitions and names are in one list, e.g. I have one table with one column for all KPI names and another column for the grouping into sections.

Is there any way in which I can put a filter on a sheet, so only data is shown that falls within one KPI-Section?

Alternatively, is it possible to filter the content of List Boxes (e.g only show KPI names if the KPI-Section is XYZ)?

I would like to do this without changing my script (because I understand I can create the above effect by making many many separate KPI lists with different names, one set for each KPI section). There must be some way to manage this in the front end options. I am currently working with version 8.5.

I am hoping for your advice.

With kind regards,

Tim

[#2]

Tim,

Yes you can filter the content of list boxes there is expression in the fields selection whenyou right click on the list box.

You can also filter on the sheet ,it all depends on what data and how you want to present it.Maybe help file using the text object and custom objects

Talha

[#3]

Hi Talha,

Wow, I thought I looked at all the options, but yes ideed, there is an 'expression' option in the field selection list.

Thanks!

I tried searching for this in the reference guide, but I missed this.

Now I will search for the same option in the Sheet properties.

With kind regards,

Tim