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.
But it gave me some worng picture.
Similarly , I tried
Lastvalue(Rate). This also gave me Worng Picture. Anybody Please help.