Question: how to calculate percentage of grand total?
Answer: You would enter a formula in the "% of Grand Total" column to divide the value in the "Total Cost" column by the grand total, then format the result as a percentage. So that you can "fill" the formula down the "% of Grand Total" column easily, you would use an absolute reference to the cell with the grand total.