Divide each departments revenue by the total revenue. Calculate a percent distribution you can use a formula that simply divides an amount by the total. Operating profit margin Operating profit Total revenue In this case we obtain.
To show percentage of total in an Excel Pivot Table create your PivotTable with the information you want summarized and then follow the steps below.
This calculation tells us that Acme Widgets. For example if a company buys shoes for 60 and sells two of them for 100 and offers a 2 discount if the balance is paid in cash the gross revenue that the company reports will be 2 x 100. Multiply that by 100 and youll have the revenue percentage change between the two periods. For example divide 450000 in non-interest expense by the 1 million sum of net interest income and non-interest income.