6 Replies Latest reply: Oct 17, 2013 2:34 AM by Nayan Lalla RSS

    Creating a Field

    Nayan Lalla


      Hi

       

      I have a table called Period.  See attached file. In the table i have a filed called MonthIndex.

      I want to create specific additonal fields for Month Index

      for eg  Max (MonthIndex)          as [Current Month]

                Max(MonthIndex) - 1       as [1 Month Ago]

                Max(MonthIndex) - 2       as [2 Months Ago]

       

      How do i do this.

       

      I know i can create this is "Variable Overview" under settings, howver i want to create it in the background script.

       

      The reason for asking tihs query (ie creating a field) is that i have a formula in the pivot table, which i think, only works with recognised fields in the background.

       

      I have attached the QV Model and Data (in excel).

       

      kind regards

      Nayan