Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
Sum(USD)/Before(Sum(USD)) - 1
Where Year is pivoted at the top
Thanks Sunny.
This worked.