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.