Hope everyone will be fine. This is my first post.
I have database linked as in clip1.
I have made a query as in clip2 , clip3 which is working fine.
I wanted to filter the data and used the filter max as in clip4.
but I see some irrelevant data is shown.
when I remove 3 fields on right side the result is ok in clip5.
I want the result like in clip5 (only 24 results) which also includes the remaining 3 relevant fields and want to drop other values from 3 right wards fields.
but when I add these fields query begins to show all the fields(37 fields) as in clip 3.
How I can get the goal?