3 Replies Latest reply on May 31, 2016 8:39 AM by Stephen Lavery

    How to use another field in filtering by formula

    Hari Sannareddy

      I would like to filter 'Accounting Period' dimension using another dimension called 'Last Month'

       

      'Accounting Period' is a discrete dimension that contains values 1 to 12 i.e., months in a calendar year.

      'Last Month' contains values 'NULL' and '4'

       

      I am filtering 'Accounting Period' using the following hard coded condition, which gives me what I need for now

       

      [Accounting Period] <= 4

       

      But, I am trying to replace '4' with 'Last Month' field and not able to make it work.

       

      Appreciate any help you can provide on this.

       

      -Hari.