Hello,
Using Excel O365. Have created a pivot table and added subtotals as below.
I want the subtotal on the MOQ field (and others not showing in the sample below) but I don't want the subtotal on the selling price, cost, margin fields as they are nonsense fields. How (if you can) switch of subtotals on a field by field basis?
[TABLE="width: 997"]
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Item Type[/TD]
[TD]ITEM DESCRIPTION[/TD]
[TD]Selling Price[/TD]
[TD]Cost[/TD]
[TD] Margin[/TD]
[TD]GM %[/TD]
[TD]Selling Price @ 45% GP[/TD]
[TD]MOQ Investment[/TD]
[/TR]
[TR]
[TD]Café Chairs[/TD]
[TD]STACKS - ARM CHAIR Colour No. 1 (Grey)[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£4,768[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 1 (Grey)[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£3,802[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 2 (White)[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£3,576[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 2 (White)[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£2,851[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 4[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£2,384[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 3[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£2,384[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 4[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£1,901[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 3[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£1,901[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Copenhagen Raw Seat[/TD]
[TD="align: right"]£9.95[/TD]
[TD="align: right"]£4.50[/TD]
[TD="align: right"]£5.45[/TD]
[TD="align: right"]54.8%[/TD]
[TD="align: right"]£8.18[/TD]
[TD="align: right"]£225[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - Vintage Copper[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - Gun Metal[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - EPC[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Shoreditch Frame R - GREY[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD]Café Chairs Total[/TD]
[TD][/TD]
[TD="align: right"]£309.55[/TD]
[TD="align: right"]£175.89[/TD]
[TD="align: right"]£133.66[/TD]
[TD="align: right"]43.2%[/TD]
[TD="align: right"]£319.80[/TD]
[TD="align: right"]£23,791[/TD]
[/TR]
</tbody>[/TABLE]
Using Excel O365. Have created a pivot table and added subtotals as below.
I want the subtotal on the MOQ field (and others not showing in the sample below) but I don't want the subtotal on the selling price, cost, margin fields as they are nonsense fields. How (if you can) switch of subtotals on a field by field basis?
[TABLE="width: 997"]
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Item Type[/TD]
[TD]ITEM DESCRIPTION[/TD]
[TD]Selling Price[/TD]
[TD]Cost[/TD]
[TD] Margin[/TD]
[TD]GM %[/TD]
[TD]Selling Price @ 45% GP[/TD]
[TD]MOQ Investment[/TD]
[/TR]
[TR]
[TD]Café Chairs[/TD]
[TD]STACKS - ARM CHAIR Colour No. 1 (Grey)[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£4,768[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 1 (Grey)[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£3,802[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 2 (White)[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£3,576[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 2 (White)[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£2,851[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 4[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£2,384[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - ARM CHAIR Colour No. 3[/TD]
[TD="align: right"]£39.95[/TD]
[TD="align: right"]£23.84[/TD]
[TD="align: right"]£16.11[/TD]
[TD="align: right"]40.3%[/TD]
[TD="align: right"]£43.35[/TD]
[TD="align: right"]£2,384[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 4[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£1,901[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STACKS - SIDE CHAIR Colour No. 3[/TD]
[TD="align: right"]£34.95[/TD]
[TD="align: right"]£19.01[/TD]
[TD="align: right"]£15.94[/TD]
[TD="align: right"]45.6%[/TD]
[TD="align: right"]£34.56[/TD]
[TD="align: right"]£1,901[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Copenhagen Raw Seat[/TD]
[TD="align: right"]£9.95[/TD]
[TD="align: right"]£4.50[/TD]
[TD="align: right"]£5.45[/TD]
[TD="align: right"]54.8%[/TD]
[TD="align: right"]£8.18[/TD]
[TD="align: right"]£225[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - Vintage Copper[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - Gun Metal[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Paris Arm Chair - EPC[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Shoreditch Frame R - GREY[/TD]
[TD][/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD]Café Chairs Total[/TD]
[TD][/TD]
[TD="align: right"]£309.55[/TD]
[TD="align: right"]£175.89[/TD]
[TD="align: right"]£133.66[/TD]
[TD="align: right"]43.2%[/TD]
[TD="align: right"]£319.80[/TD]
[TD="align: right"]£23,791[/TD]
[/TR]
</tbody>[/TABLE]