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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

percentage question 6
Challenging the GOAL SEEK function within a bonus scheme 6
Add percentage to a whole column of numbers 1
how can I get a percentage on excel 2002 1
Two totals in one cell shown in two separate columns 6
Count Number of Discrete Cells, Based on Another Column 8
calculate percentage between number of exams total missed exams 3
Work out the percentage 4

Top