Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator III

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

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

1 Solution

Accepted Solutions
Creator III
Author

Hi ,

Finally I solved  .

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

Creator III
Author

Hi ,

Finally I solved  .

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

Community Browser