Filter table based on two dates

[#1]

Hi,

I need to filter a table based on two dates which can be selected by the user.

Has someone a solution?

Kind regards

Michael

[giakoum · Accepted solution]

You need to add set analysis in every expression as follows :

=only({<DATEBON={">=$(DateLower)<$(DateUpper)"}>} BUDGET)

I used only as a function, you may use sum or whatever is suitable for your data.

DateLower and DateUpper as variables the user date selection is assigned to. You cannot use a field, as this would reduce data to the selected value only (unless it is a data island)

[#3]

Hi Ioannis,

thanks for the solution. It's working

Michael