add column for percentage o total

D

derwood

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
 
H

Herbert Seidenberg

Right-click on "Sum of ...."
Field Settings > Options > Show data as > % of total
 
Top