Excel - Pivot table help please

[Royal Fleet]

I have tried Googling for this but without being able to nail down exactly what I am trying to do here.

I have created a Pivot table from a dataset. It has underneath each geographic region 2 columns for a year, 2018 and 2019.

At present within each row therefore it has a 2018 column value and 2019 column value for each line of business (the rows). Excel as a default then includes a subtotal

So something like this

______________2018___2019___Sub Total
LOB A__________25_____50______75\
(Etc)

What I want to be able to do is to change the Subtotal into a % change so in the example above the Subotoal of 75 would change to 100% increase (being (50-25)/25 - expressed as a percentage).

Is there a way to do this without just copying and pasting the values out and doing manually. I have many filters to repeat this with so that will be laborious.

Any help appreciated

 

[Royal Fleet]

To add, my solution needs 2018 and 2019 data to be in separate columns in your source table rather than rows

That is probably why I couldn’t get the solution from Googling. My data is all in rows with year as a single column. Not a lot I can do about that due to the nature of the presented data.

Thanks for your help. I’ll have a look at Meeko’s solution.