hi,
I have below query. It’s working fine .. i just need to group the results by the ID
i tried to create group by ID, datex, [under 1], [1-6]
It gives me error message (status = 'Open' And [table1].datex <=#3/31/2022#) is not part of the segregated group by
What is the best way to group the...