calculated dimension using max date per constant string

[wiz_nerd]

I am trying to create a calculated dimension in which I need to consider (distinct max date and distinct Name_String)  to conclude output_string? Note Date is in RFC format

Name_String	date	output_string
string1	date1	string1_yyw3
string1	date3	string1_yyw2
string1	date3	string1_yyw1
string2	date1	string2_yyw1
string2	date3	string2_yyw2
string2	date3	string2_yyw3

Output:

string1

date3

string1_yyw1

string2

date3

string2_yyw3

[agigliotti]

why do you need string1_yyw1 rather than string1_yyw2 as output for string1 ?
what does the logic behind it is ?

[wiz_nerd]

I need the output with respect to the constant_string and date and I need both the values as they are distinct.