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?
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
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 Type | ITEM DESCRIPTION | Selling Price | Cost | Margin | GM % | Selling Price @ 45% GP | MOQ Investment |
Café Chairs | STACKS - ARM CHAIR Colour No. 1 (Grey) | £39.95 | £23.84 | £16.11 | 40.3% | £43.35 | £4,768 |
STACKS - SIDE CHAIR Colour No. 1 (Grey) | £34.95 | £19.01 | £15.94 | 45.6% | £34.56 | £3,802 | |
STACKS - ARM CHAIR Colour No. 2 (White) | £39.95 | £23.84 | £16.11 | 40.3% | £43.35 | £3,576 | |
STACKS - SIDE CHAIR Colour No. 2 (White) | £34.95 | £19.01 | £15.94 | 45.6% | £34.56 | £2,851 | |
STACKS - ARM CHAIR Colour No. 4 | £39.95 | £23.84 | £16.11 | 40.3% | £43.35 | £2,384 | |
STACKS - ARM CHAIR Colour No. 3 | £39.95 | £23.84 | £16.11 | 40.3% | £43.35 | £2,384 | |
STACKS - SIDE CHAIR Colour No. 4 | £34.95 | £19.01 | £15.94 | 45.6% | £34.56 | £1,901 | |
STACKS - SIDE CHAIR Colour No. 3 | £34.95 | £19.01 | £15.94 | 45.6% | £34.56 | £1,901 | |
Copenhagen Raw Seat | £9.95 | £4.50 | £5.45 | 54.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.66 | 43.2% | £319.80 | £23,791 |
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>