%Change YOY

[vardhancse]

Hi,

Have one requirement is that, required one line graph showing the %Change YOY based on the selection of metric.

**Its rolling 12 months based on the year and month filter.

Applied below expression:

Sum({<FYYear=,MonthName=,DateFull={">=$(=MonthStart(Max(DateFull),-12))<=$(=Date(Max(DateFull)))"}>}Actual)

But the requirement was :

Formula = (Current Value – Previous Value) / Absolute(Previous Value)

PFA sample application.

Thanks in advance.

[MK_QSL]

Like this?

[vardhancse]

Hi Manish,

Thanks for your reply.

Sorry this is not my requirement.

1.Based on selected month and year, rolling 12 months like graph in terms of %

2. The graph should be %change YOY

Formula = (Current Value – Previous Value) / Absolute(Previous Value)

E.g:

FYMonth	FYYear	Month	MonthShort	Actual	DateFull	Metric
Jan-2013	2013	January	Jan	10	1/1/2013	M1
Feb-2013	2013	February	Feb	20	1/2/2013	M1
Mar-2013	2013	March	Mar	30	1/3/2013	M1
Apr-2013	2013	April	Apr	40	1/4/2013	M1
May-2013	2013	May	May	50	1/5/2013	M1
Jun-2013	2013	June	Jun	60	1/6/2013	M1
Jul-2013	2013	July	Jul	70	1/7/2013	M1
Aug-2013	2013	August	Aug	80	1/8/2013	M1
Sep-2013	2013	September	Sep	90	1/9/2013	M1
Oct-2013	2013	October	Oct	100	1/10/2013	M1
Nov-2013	2013	November	Nov	110	1/11/2013	M1
Dec-2013	2013	December	Dec	120	1/12/2013	M1
Jan-2014	2014	January	Jan	15	1/1/2014	M1
Feb-2014	2014	February	Feb	25	1/2/2014	M1
Mar-2014	2014	March	Mar	35	1/3/2014	M1
Apr-2014	2014	April	Apr	45	1/4/2014	M1
May-2014	2014	May	May	55	1/5/2014	M1
Jun-2014	2014	June	Jun	65	1/6/2014	M1
Jul-2014	2014	July	Jul	75	1/7/2014	M1
Aug-2014	2014	August	Aug	85	1/8/2014	M1
Sep-2014	2014	September	Sep	95	1/9/2014	M1
Oct-2014	2014	October	Oct	105	1/10/2014	M1
Nov-2014	2014	November	Nov	115	1/11/2014	M1
Dec-2014	2014	December	Dec	125	1/12/2014	M1

Selected month and year: Jun-2014

Graph should show jun-2014 to back jun-2013.

=(65-60)/60=8.33%

so in graph it should show for jun-2014: 8.33

similarly for all the 12 months back to the jun-2014

[MK_QSL]

How 65 and 60 is coming for Jun-2014?

Please clarify!

[vardhancse]

Jun-2014: 65

Jun-2013: 60

**Please note that this is sample data

[MK_QSL]

Like this?