Hi,
I have 2 date fields(entry date, exit date), 1 result field, and a policy number.
I need to build the straight table chart in which I should have policy number record with min entry date and max exit date
Eg
Policy Number Entry Date Exit Date Result
1 24/11/2023. 21/10/2024. 100
1 20/12/2022. 21/10/2024. 50
2. 22/01/2020. 02/02/2023. 20
My resultant should be
Policy Number Entry Date Exit Date Result
1 20/12/2022. 21/10/2024. 50
2. 22/01/2020. 02/02/2023. 20
I tried using first sorted to get the date fields but for measure Result i am unable to get the proper values.
please help me on the above
Thanks