8 Replies Latest reply on Nov 19, 2014 12:36 PM by Matt Lutton

    Lookup function to find the Last Value of a Previous partition?

    Patrick Carpenito

      Can someone help with a table calculation that uses the Lookup function to find the Last Value of a Previous partition?

       

      I am able to get the Last value of the same partition (See Below), but I need the last value of the Previous Partition.

       

      LOOKUP(SUM([Value]),Last())