Pivot table subtotals for certain fields

Ed_Global

New Member
Joined
Jul 11, 2017
Messages
12
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?

Item TypeITEM DESCRIPTIONSelling PriceCost MarginGM %Selling Price @ 45% GPMOQ Investment
Café ChairsSTACKS - ARM CHAIR Colour No. 1 (Grey)£39.95£23.84£16.1140.3%£43.35£4,768
STACKS - SIDE CHAIR Colour No. 1 (Grey)£34.95£19.01£15.9445.6%£34.56£3,802
STACKS - ARM CHAIR Colour No. 2 (White)£39.95£23.84£16.1140.3%£43.35£3,576
STACKS - SIDE CHAIR Colour No. 2 (White)£34.95£19.01£15.9445.6%£34.56£2,851
STACKS - ARM CHAIR Colour No. 4£39.95£23.84£16.1140.3%£43.35£2,384
STACKS - ARM CHAIR Colour No. 3£39.95£23.84£16.1140.3%£43.35£2,384
STACKS - SIDE CHAIR Colour No. 4£34.95£19.01£15.9445.6%£34.56£1,901
STACKS - SIDE CHAIR Colour No. 3£34.95£19.01£15.9445.6%£34.56£1,901
Copenhagen Raw Seat£9.95£4.50£5.4554.8%£8.18£225
Paris Arm Chair - Vintage Copper£0.00£0.00#DIV/0!£0.00£0
Paris Arm Chair - Gun Metal£0.00£0.00#DIV/0!£0.00£0
Paris Arm Chair - EPC£0.00£0.00#DIV/0!£0.00£0
Shoreditch Frame R - GREY£0.00£0.00#DIV/0!£0.00£0
Café Chairs Total£309.55£175.89£133.6643.2%£319.80£23,791

<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,214,589
Messages
6,120,416
Members
448,960
Latest member
AKSMITH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top