Now to convert them into percentage select the cells and press CTRLSHIFT. Ill show you how to use this to make quick work of calculating a column of percentages. In the Value Field Settings window on the Show Values As tab choose of Column Total.
To do this first select one of the Total values that you wish to display as a percentage of the Grand Total.
Select a cell in a formatted table. Calculate a percent distribution you can use a formula that simply divides an amount by the total. The excel formula for percentage is Portion Days Total Days 100. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.