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.
[TABLE="width: 413"]
<tbody>[TR]
[TD] [/TD]
[TD="colspan: 2"]Column Labels in Months[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Mar-18[/TD]
[TD]Apr-18[/TD]
[TD]May-18[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Kiwi[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]
[TABLE="width: 413"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]
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.
[TABLE="width: 413"]
<tbody>[TR]
[TD] [/TD]
[TD="colspan: 2"]Column Labels in Months[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Mar-18[/TD]
[TD]Apr-18[/TD]
[TD]May-18[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Kiwi[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cost [/TD]
[TD] $ 5.00 [/TD]
[TD] $ 7.00 [/TD]
[TD] $ 6.55 [/TD]
[/TR]
[TR]
[TD]Price[/TD]
[TD] $ 4.00 [/TD]
[TD] $ 6.00 [/TD]
[TD] $ 3.55 [/TD]
[/TR]
[TR]
[TD]Labor Hours[/TD]
[TD]20[/TD]
[TD]35[/TD]
[TD]26[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]
[TABLE="width: 413"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]