1 Reply Latest reply: Mar 27, 2014 8:59 AM by Manish Kachhia RSS

    Last Value Monthwise

      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.