Last Value Monthwise

[#1]

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.

[MK_QSL]

You can use

firstsortedvalue(DISTINCT Rate,-Date)