In Sheets, with the grand total in D14, type the share-of-total formula for row 2 that survives a fill down.
In Sheets, with the grand total in D14, type the share-of-total formula for row 2 that survives a fill down.
Answer
=D2/D14
The numerator is relative and follows each row; the denominator is absolute and stays on the total. Filled down: 0.0684, 0.0293, 0.1238, …