Reputation: 43
I have a table and in Column 1 is a list of companies, and company names may appear more than once because Column 2 is a year. Column 3 is the amount a company spent in that respective year. How can I show the percent differences between each year without spilling into the next company? For instance Company, A is 2017-2020 and i want to show the % growth for that. But the next row is Company B for 2017-2020 and I don't want to calculate the % between the values for 2020 Company A and 2017 Company B.
Upvotes: -1
Views: 232
Reputation:
To calculate the % between the values for different companies:
Read more about calculating percentages at support.microsoft.com. Hope it helps, Please upvote!
Upvotes: 2
Reputation: 12008
You can use a Pivot Table for this:
As you can see, Company A
invested 1000 on 2017 and 2000 on 2018. So 2000-1000=1000
and '1000 / 2017 investment (which is 1000)= 100%'
Company A
invested 3000 on 2019 and 2000 on 2018. So 3000-2000=1000
and '1000 / 2018 investment (which is 2000)= 50%'
And so on.
About Pivot Tables, check:
My setup in Pivot Table is:
Company
into rows sectionYear
into Columns SectionAmount
must change setup. Change option show values as and choose % difference with previous yearUpvotes: 0