To show growth of current year RQTR vs previous year RQTR in Bar Chart

[hemanthaanichet]

Hi ,

Previously I posted this requirement in the blog  but  due to some urgency once again iam posting this

Rollling Quater Growth:

Formula: ( RQTR of Current Year  -  RQTR of Previous Year) / (RQTR of Previous Year )

Current year is latest 12 months i.e., Oct-12 - Sep-13

Previous year is previous latest 12 months i.e., Oct-11 - Sep12

Dimension should be latest 12 months i.e., Oct-12 - Sep-13

&

Sep-13 have a value which is equal to sum of sales for Sep-13,Aug-13,Jul-13

i.e., Sep-13 = sum({<Yearmonth={ Sep-13,Aug-13,Jul-13}>}sales)

       Aug-13 = sum({<Yearmonth={ Aug-13,Jul-13,Jun-13}>}sales)

       Jul-13 = sum({<Yearmonth={ Jul-13,Jun-13,May-13}>}sales)

like so on for remaining

Regards

Hemanth

[hemanthaanichet · Accepted solution]

Hi ,

Finally I solved  .

Thank Sunny for your helpful Ideas,Suggestions and Trick work

Here is the expression:

((above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -13), 'MMM-YY') & '<=' & Date(Max(YearMonth), 'MMM-YY'))"}>}Sales),0,3)),2))

/

(above(rangesum(below(sum({<Year=,Month=,YearMonth ={"$(='>=' & Date(AddMonths(Max(YearMonth), -25), 'MMM-YY') & '<=' & Date(AddMonths(Max(YearMonth), -12), 'MMM-YY'))"} >}Sales),0,3)),14)))-1

Regards

Hemanth