Calculate % of Totals

[anamik72]

Here is my Input and Output table with sample dataset. Can you help build the right formula for % increase with Totals? Thanks

Input Table
Customer	19 Revenue	20 Revenue	19 Profit	20 Profit
Cust A	$          100	$          140	$       50	$       65
Cust B	$          150	$          225	$       15	$       20

Output Table
Customer	19 Revenue	20 Revenue	19 Profit	20 Profit	Revenue % Growth	Profit % Growth
Cust A	$          100	$          140	$       50	$       65	40%	30%
Cust B	$          150	$          225	$       15	$       20	50%	33%
Total	$          250	$          365	$       65	$       85	46%	31%

[AbhilashR · Accepted solution]

Hi @anamik72, would the attached solution work on your larger dataset? 

Output: