Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,585
- Office Version
- 365
- 2013
- Platform
- Windows
I want to combine below 2 lines together in pivot table
1. Installations HW - Fidelity
2. Installations HW - Fidelity Non Coverages
1. Installations HW - Fidelity
2. Installations HW - Fidelity Non Coverages
| October 20 job Costing.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 3 | Service | Sales | Labor Cost | Labor Margin % | Equipment Cost | Equipment Margin % | ||
| 4 | Installations - Demand | $ 8,006 | $ 550 | 6.87% | $ 4,438 | 55.43% | ||
| 5 | Installations HW - Fidelity Non Coverages | $ 14,050 | $ 1,250 | 8.90% | 0.00% | |||
| 6 | Installations HW - First American Non Coverages | $ 16,436 | $ 2,500 | 15.21% | 0.00% | |||
| 7 | Installations HW - HWA Non Coverages | $ 8,916 | $ 800 | 8.97% | 0.00% | |||
| 8 | Maintenance - Demand | $ 2,216 | $ 1,600 | 72.21% | 0.00% | |||
| 9 | Service - Demand | $ 4,970 | $ 1,350 | 27.16% | 0.00% | |||
| 10 | Service HW - Fidelity | $ 2,955 | $ 1,000 | 33.84% | 0.00% | |||
| 11 | Service HW - Fidelity Deductible | $ 815 | $ 250 | 30.67% | 0.00% | |||
| 12 | Service HW - First American | $ 6,080 | $ 1,450 | 23.85% | 0.00% | |||
| 13 | Service HW - First American Deductible | $ 1,000 | $ 550 | 55.00% | 0.00% | |||
| 14 | Service HW - HWA | $ 1,015 | $ 400 | 39.41% | 0.00% | |||
| 15 | Service HW - HWA Deductible | $ 340 | $ 200 | 58.82% | 0.00% | |||
| 16 | Warranty - Warranty | $ - | $ 400 | #DIV/0! | #DIV/0! | |||
| 17 | Installations HW - Fidelity | $ 1,640 | $ 250 | 15.24% | 0.00% | |||
| 18 | Service HW - Choice Deductible | $ 60 | $ 50 | 83.33% | 0.00% | |||
| 19 | Service HW - AHS | $ 305 | $ 150 | 49.18% | 0.00% | |||
| 20 | Installations HW - AHS Non Coverages | $ 10,950 | $ 1,000 | 9.13% | $ 1,200 | 10.96% | ||
| 21 | Grand Total | $ 79,754 | $ 13,750 | 17.24% | $ 5,638 | 7.07% | ||
Sheet2 | ||||||||
