Max Date disregard ID

[BigKev]

Hi Everyone,

My Data consist of ID and ACT_DT. Could anyone please help me to achieve the 'Max_ACT_Date' column. Essentially is the maxof ACT date?

I have tried max({1}Act_DT), but it give me the max of date of each row, which is ACT_DT.

Thanks. 

ID	ACT_DT	max_ACT_Date
1	1/02/2020	1/10/2020
2	1/03/2020	1/10/2020
3	1/04/2020	1/10/2020
4	1/05/2020	1/10/2020
5	1/06/2020	1/10/2020
6	1/07/2020	1/10/2020
7	1/08/2020	1/10/2020
8	1/09/2020	1/10/2020
9	1/10/2020	1/10/2020

[martinpohl · Accepted solution]

so use

max({1}total Act_DT)

instead

[BigKev]

Thank you mate.. It works like Magic 🙂