ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   add column for percentage o total (https://www.excelbanter.com/excel-discussion-misc-queries/170823-add-column-percentage-o-total.html)

derwood[_2_]

add column for percentage o total
 
in pivottabes i have a row of names with the relevant customer spend shown
alongside. there is the sum total shown at the end.. how can i create a
column that reflects each customer spend as a percentage of the total....
thanks in anticipation

Herbert Seidenberg

add column for percentage o total
 
Right-click on "Sum of ...."
Field Settings Options Show data as % of total


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com