How to properly format a table?

Question

excel

All the best! Please tell me there is a pivot table with dynamic expansion.

You need to make a table of the difference in percentages.
I can’t figure out how to make it so that it is dynamic and adapts to the main table.
How to make it?
Please help with advice!
using the formula ( =100% - (B$14 - B8)/B$14 )

Answer 1

If I'm not mistaken, pivot tables have the ability to display the result immediately as a percentage.