charcoop14
New Member
- Joined
- Jul 28, 2014
- Messages
- 17
Hello all,
I need help in creating a pivot table with the below example. I cant seem to find info on creating this. First Row is FRUIT, then I want the sub row informations below it (Cost, Price, Labor Hours) under it for each fruit field.
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
I need help in creating a pivot table with the below example. I cant seem to find info on creating this. First Row is FRUIT, then I want the sub row informations below it (Cost, Price, Labor Hours) under it for each fruit field.
Column Labels in Months | |||
Row Labels | Mar-18 | Apr-18 | May-18 |
Banana | |||
Cost | $ 5.00 | $ 7.00 | $ 6.55 |
Price | $ 4.00 | $ 6.00 | $ 3.55 |
Labor Hours | 20 | 35 | 26 |
Apple | |||
Cost | $ 5.00 | $ 7.00 | $ 6.55 |
Price | $ 4.00 | $ 6.00 | $ 3.55 |
Labor Hours | 20 | 35 | 26 |
Kiwi | |||
Cost | $ 5.00 | $ 7.00 | $ 6.55 |
Price | $ 4.00 | $ 6.00 | $ 3.55 |
Labor Hours | 20 | 35 | 26 |
Orange | |||
Cost | $ 5.00 | $ 7.00 | $ 6.55 |
Price | $ 4.00 | $ 6.00 | $ 3.55 |
Labor Hours | 20 | 35 | 26 |
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>