Hi
I have this data
I'm building a Straight table to show historical records, depending on a field selection ([Calendar Month Year])
e.g. If the user selects Jul-2021, i should see all records
If the user selects Jun-2021, I should see records match with selection (dates between Start and End date)
I am using this expression with Set Analysis in my Dimension
=Aggr(Only({
<
MonthYear = ,
[Program Name] = {'Prog 1'},
[Enrollment Status End Date]={"<=$(=MonthEnd(Max([Calendar Month Year])))"}
>
+
<
MonthYear=,
[Program Name] = {'Prog 1'},
[EnrollMent Status End Date Status] = {1}
>
}
Customer),
Customer
)
Currently, when i select Jun-2021, only shows
Any suggestions?
Thanks in advance.
Note1: [EnrollMent Status End Date Status] field is for check if the value is null (1: null, 0: not null).
Note2: [Calendar Month Year] field is from an island table.