Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
| 690 | |
c | 11/19/2016 | 333 | 11/12/2016 | 140 |
Thanks..
PFA
You may use this for calculated Dim and use Name
If(WeekDay(Date) = 'Sat', Date)
Then Expresssion could be Sum(Profit)
Hi Kishore,
This might help you :
=FirstSortedValue(Profit,if(WeekDay(Sort_Date)='Sat',Sort_Date))
Regards,
Nitin
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 |
| 690 | |
c | 11/19/2016 | 333 | 11/12/2016 | 140 |
Can you please help me.
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 |
| 690 | |
c | 11/19/2016 | 333 | 11/12/2016 | 140 |