Need Help

[#1]

Hi Experts,

    I have a scenario like this, i need to show the recent status for every 'id' PFA . I need to show that in straight table

with out any selections

[MK_QSL · Accepted solution]

Check enclosed file

[MK_QSL]

check enclosed file

[rustyfishbones]

Use FIRSTSORTEDVALUE

[#5]

Hi Manish,

     i want to show the date also for that status

[rustyfishbones]

Try below, you may need to format the Date

DATE(FirstSortedValue(date,-date),'DD/MM/YYYY')

[MK_QSL]

Try FirstSortedValue(date,-date)