Getting Particular dates using firstsortedvalue

[Anonymous]

Hi,

Consider 3 fields from a table.

Name	Date	Profit
a	11/26/2016	100
a	11/21/2016	200
a	11/19/2016	230
b	11/26/2016	454
b	11/19/2016	690
b	11/12/2016	500
c	11/21/2016	123
c	11/19/2016	333
c	11/12/2016	140

from this table, i need to get the Names which are on saturday's (26,19,12).

Like below, can we achieve this using firstsortedvalue function.? or with something else?

What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.

Name	max Date	Profit	Previous Date	Profit
a	11/26/2016	100	11/19/2016	230
b	11/26/2016	454	11/19/2016	690
c	11/19/2016	333	11/12/2016	140

Getting Particular dates using firstsortedvalue

Thanks..

[tresesco]

PFA

[Anil_Babu_Samineni]

You may use this for calculated Dim and use Name

If(WeekDay(Date) = 'Sat', Date)

Then Expresssion could be Sum(Profit)

[nitin_01]

Hi Kishore,

         This might help you :

                                              =FirstSortedValue(Profit,if(WeekDay(Sort_Date)='Sat',Sort_Date))

Regards,

Nitin

[Anonymous]

Hi ill change my requirement.

Name	Date	Profit
a	11/26/2016	100
a	11/21/2016	200
a	11/19/2016	230
a	11/14/2016	150
b	11/26/2016	454
b	11/19/2016	690
b	11/12/2016	500
c	11/21/2016	123
c	11/19/2016	333
c	11/12/2016	140

What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.

Name	max Date	Profit	Previous Date	Profit
a	11/26/2016	100	11/19/2016	230
b	11/26/2016	454	11/19/2016	690
c	11/19/2016	333	11/12/2016	140

Can you please help me.

[Anonymous]

Hi ill change my requirement.

Name	Date	Profit
a	11/26/2016	100
a	11/21/2016	200
a	11/19/2016	230
a	11/14/2016	150
b	11/26/2016	454
b	11/19/2016	690
b	11/12/2016	500
c	11/21/2016	123
c	11/19/2016	333
c	11/12/2016	140

What i want is like below, It should pick only saturday on max Date and Previous Date and those corresponding values.

Name	max Date	Profit	Previous Date	Profit
a	11/26/2016	100	11/19/2016	230
b	11/26/2016	454	11/19/2016	690
c	11/19/2016	333	11/12/2016	140