Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter table based on two dates

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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

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)

View solution in original post

2 Replies
giakoum
Partner - Master II
Partner - Master II

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)

Not applicable
Author

Hi Ioannis,

thanks for the solution. It's working

Michael