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

# 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:ZMItemName=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`

• ###### Set analysis for growth

Hi All,

Have attached the document to work on. Hope some one can provide me the solution.