Addition of Calculated Field

[vikas_nandanwar]

Hi All,

I have my data in below

I need a calculated field in pivot giving result as -

[Sum 2016(USD) - Sum 2015(USD) ] / [Sum 2015(USD)]

Please help.

Year	USD		2015	2016	Growth
2016	2000	Sum of USD	20700	21800	5.02%
2016	2600
2016	2800
2016	3400
2016	3000
2016	6600
2016	800
2016	600
2015	5400
2015	4600
2015	4200
2015	2000
2015	700
2015	300
2015	2200
2015	800
2015	500

Regards,

Vikas

[sunny_talwar]

May be like this

Sum(USD)/Before(Sum(USD)) - 1

Where Year is pivoted at the top

[vikas_nandanwar]

Thanks Sunny.

This worked.