Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need last rate of items from its rate field monthly and yearly itemwise.
I have year , Month, Items, Rate,Date fields. So , How can i get itemwise value monthly and yearly.
i tried
firstsortedvalue(Rate,-Date)
But it gave me some worng picture.
Similarly , I tried
Lastvalue(Rate). This also gave me Worng Picture. Anybody Please help.
You can use
firstsortedvalue(DISTINCT Rate,-Date)