5 Replies Latest reply on Feb 6, 2013 9:29 PM by Joe Mako

    Is there a formula to pick the last value in a partition?

    Siew Wong

      Hi,

      Is there a way to pick the last value in a partition? See my data layout below.I'd like to sum across a few categories using only the last value of the partition's time period. When time period is changed to monthly, it'd take the last day of the month's value.

       

      Screen Shot 2013-01-23 at 1.09.11 PM.png

       

      Appreciate any help on this.

       

      Thanks,

      Siew