Pivot table help

Y

Yossy

please I want to do a calculation Individual cost/Total cost.

Let say I have:
A1 100
A2 20
A3 40
Total 160

Calculate for A2 = 20/160. Can I do this inside pivot table. Any help
totally appreciated. Thanks
 
S

Shane Devenshire

Hi,

1. Add the Cost field to your pivot table Data area a second time
2. Drag the Data button to the Column Area
3. Right-click in the Cost2 column and choose Field Settings,
4. Click Options
5. Open the Show data as drop down and choose % of Total, (scroll down to
find it)

Click OK

If this is helpful, click the Yes button

Cheers,
Shane Devenshire
 

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

Dealing with a Pivot Table (when I don't want to) 0
Work Budget Salary vs Real Time Salary 0
Calculate end date and time 1
Excel - Wich Function should I use? 1
Pivot table 0
pivot table help 0
N/A in pivot table become 0 1
Multiple If statements, Calculating quarterly % holding costs 0

Top