1 Reply Latest reply: Dec 19, 2013 1:49 AM by AlexH RSS

    Ago function cannot show the correct data

    AlexH

      I created a logic columns to get the measure of last month. No error occurs but only get the unexpected data.

      Dont know why. Any advise?

       

      Logic column: Count of Last Month=ago("TEST"."Fact Transaction"."Count" , "TEST"."Time Hierarchy"."Month" ,1)

       

      Result:

      Month
      CountCount of Last Month
      4770
      5130130
      6240240
      7180180
      8220220

       

      Time Hierarchy:

      Total->Year->Quarter->Month->Date->Hour->DateTime(key of the time dimension table)

       

      Ticked the 'Time Hierarchy' and set the 'Chronological Key' for each level.

       

      Have to mention that I created 2 Hierarchies for the time dimension table. The 2nd hierarchy is as below:

      Date Hierarchy:

      Total->Year->Quarter->Month->Date