7 Replies Latest reply on Apr 5, 2013 2:29 AM by Stuart Matthews

    Can I restrict a parameter to work on the latest column value (I.e. year)?

    Robert Bell

      HI

       

      Please see the first sheet (sheet 26) in the attached twbx.

       

      I've set up a parameter and an associated calculated field to restrict rows to programmes that have >= the specified no. of applications. However, I'd like it to restrict the results to only where the 2013/4 number of applications is >= the parameter, irrespective of previous years.

       

      Is this possible?

       

      Any advice will be gratefully received!

       

      Many thanks

       

      Bob