Filtering a table based on a list box value

[sayadutt]

Hi,

I have a list box which contains dates.

My requirement is to create a filter on my table which will show the value for max(Date) (by default).

I can't use "Select In Field" at Document level, as I need this filter only for this table. I have other tables in my page as well which shows All days data.

Can you please help.

[Vegar · Accepted solution]

Add a set analysis into your expressions.

Like this: Sum({<Date={'$(=maxstring([Date]))'}>}Qty)