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

    Creating a Field



      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