percentage change over year/month

[#1]

Hi there,

I have created a pivot table sheet object.

How can i add an expression for Sales to show the % change for year-on-year?

As in below:

Month	2014	2015	% Chng
1	67,702	72,170	7%
2	57,057	62,895	10%
3	78,587	76,086	-3%
4	78,795	78,463	0%
5	77,622	79,552	2%
6	71,801	76,178	6%
7	77,978	71,959	-8%
8	76,734	70,606	-8%
9	75,039	74,484	-1%
10	82,975	81,524	-2%
11	78,675	78,233	-1%
12	18,042	17,889	-1%

[Anonymous]

Good...

Once you create Year based on Date field, it would be interger only...

How you have created Year??

[sunny_talwar]

Remove the check from the check box for  'Show in Percent (%)'

[Anonymous]

Ohh..Again misunderstood... he was asking for data in column of 2014 & 2015

[#5]

‌hi all,

if I remove the  check box for show in percentage then the %Chng will not show in percentage. Show as 0

[sunny_talwar · Accepted solution]

Use expression default formatting and then use the following expression:

=If(SecondaryDimensionality() = 0, Num(Sum({<Year = {'$(=Max(Year))'}>} Data)/Sum({<Year = {'$(=Max(Year) - 1)'}>} Data) - 1, '0%'), Num(Sum(Data), '#,##0.0'))

[#7]

Thanks all, solved the problem!

[sunny_talwar]

Awesome

[#9]

Sunny,

Can you please demonstrate how you take that one step further and show the Aggregating Year over Year percentage change by month?  As opposed to the incremental monthly percent change per the examples.

I need to show the cumulative percentage change YoY, by month, so that period 12 would be the same as the Total.

Thanks in advance

[saachu21]

Simple Solution, I hope you all like it. Suggestion always welcome.

In expression tab, add this expression to get the column as per your expectation.

=Round(Num((Sum([2015]) - Sum([2014]))/ (Sum([2014]))*100, '#.##'))&'%'

[vj_analysis]

How secondary dimensional is working in this expression  could you please explain