The grand totals for rows show that 2014 accounts for 3195 of the total sales. Now to convert them into percentage select the cells and press CTRLSHIFT. The goal here is for us to transform numbers from a decimal format ie.
For example to find the percent of total sales per segment.
And then we use the DIVIDE function to calculate the percent contribution. Calculate a percent distribution you can use a formula that simply divides an amount by the total. Add up 100 400 600 1100. For example Technology in the East region accounts for 379 of total sales in 2014.