add column for percentage o total

  • Thread starter Thread starter derwood
  • Start date Start date
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
 
Right-click on "Sum of ...."
Field Settings > Options > Show data as > % of total
 
Back
Top