Set analysis for growth

[#1]

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

[#2]

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

[#3]

Hi All,

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