lemonteadrink
New Member
- Joined
- Nov 22, 2014
- Messages
- 13
How do I get profit percentage in pivot table ? There is contract sum and cost.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do I get profit percentage in pivot table ?
- Thread starter lemonteadrink
- Start date
-
- Tags
- cost percentage pivot profit table
Excel Facts
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
sheetspread
Well-known Member
- Joined
- Sep 19, 2005
- Messages
- 5,160
One way is a calculated field:
| Excel 2010 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | Project | Contract Sum | Cost | Row Labels | Sum of Contract Sum | Sum of Cost | Sum of Field1 | |||
| 2 | Q | 5929 | 3355 | E | 3510 | 1200 | 65.81% | |||
| 3 | W | 5194 | 1482 | I | 4653 | 698 | 85.00% | |||
| 4 | E | 3510 | 1200 | O | 12329 | 6085 | 50.64% | |||
| 5 | R | 8113 | 6957 | Q | 5929 | 3355 | 43.41% | |||
| 6 | T | 9361 | 6194 | R | 8113 | 6957 | 14.25% | |||
| 7 | Y | 3847 | 1807 | T | 9361 | 6194 | 33.83% | |||
| 8 | U | 9828 | 3952 | U | 9828 | 3952 | 59.79% | |||
| 9 | I | 4653 | 698 | W | 5194 | 1482 | 71.47% | |||
| 10 | O | 12329 | 6085 | Y | 3847 | 1807 | 53.03% | |||
Sheet6 | ||||||||||
Upvote
0
Similar threads
- Replies
- 0
- Views
- 54
- Replies
- 0
- Views
- 333
- Replies
- 27
- Views
- 1K
- Question
- Replies
- 0
- Views
- 216
- Replies
- 1
- Views
- 195
