2 Replies Latest reply on Apr 3, 2012 6:10 AM by philip.sivyer

    Can you create a formulae to select previous or next value in a summarised field eg

      Example data set...

                                  Region

      Company               UK        

      CpyA                    10          

      CpyB                    12        

      CpyC                    56         

       

      If possible...(add column for Previous Value)

      CpyA                    10     NULL

      CpyB                    12     10

      CpyC                    56     12

       

      Regards