2 Replies Latest reply: Sep 16, 2010 8:27 AM by At titude RSS

    Set analysis for growth

      Hi All,

      I want to calculate the growth of a item.

      Current year,selected month vs Previous year selected month

      Please let me know was I am doing that in right way?

       


      (Sum({$<YEAR={$(=Max(YEAR(TranDate)))},MONTH={$(=Max(Month(TranDate)))}>} Qty) / Sum({$<YEAR={$(=Max(YEAR(TranDate))-1)},MONTH={$(=Max(MONTH(TranDate))-1)}>} Qty))*100-100


       

        • Set analysis for growth

          Hi All,

          I have given the selected field and expression of my pivot table.

          What exactly I want to calculate is to what is the growth of month when compared to the previous year of the same month.

          Some one please let me know whats wrong with this Set Analysis! I am not getting any values in the growth expression.

           


          Dimension:

          ZM

          ItemName

          =MonthName(TranDate)

          Expressions:

          (Sum({$<YEAR={$(=Max(YEAR(TranDate)))},MONTH={$(=Max(Month(TranDate)))}>} Qty) / Sum({$<YEAR={$(=Max(YEAR(TranDate))-1)},MONTH={$(=Max(MONTH(TranDate))-1)}>} Qty))*100-100