Anglais428v2
New Member
- Joined
- Jun 19, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hello,
I have created a table visualization (see below). I would like to add another column that will calculate the growth between indicators and years. So for example, I would like to calculate the growth between 2014 and 2015 for inflation ((0.04-1.46) / 1.46); then 2015 v 2016 for inflation etc. It would then need to leave a gap when it starts a new data point (e.g. Unemployment rate 2014 should be blank, but unemployment rate 2015 v 2014 should be calculated.
Any advice?
I have created a table visualization (see below). I would like to add another column that will calculate the growth between indicators and years. So for example, I would like to calculate the growth between 2014 and 2015 for inflation ((0.04-1.46) / 1.46); then 2015 v 2016 for inflation etc. It would then need to leave a gap when it starts a new data point (e.g. Unemployment rate 2014 should be blank, but unemployment rate 2015 v 2014 should be calculated.
Any advice?
