Showing only total in pivot table for some of the items

[turezky]

Consider the following data set:

[TABLE="width: 437"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Product[/TD]
[TD]Unit Price[/TD]
[TD]Sales Volume[/TD]
[TD]Revenue[/TD]
[TD]Discount  %[/TD]
[TD]Discount Value[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]2.5[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]6.25[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]7.5[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]175[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]8.75[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]11.25[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]12.5[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]275[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]13.75[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]325[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]16.25[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]3.6[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]4.2[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]4.8[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]5.4[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]220[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]6.6[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]7.2[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]260[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]7.8[/TD]
[/TR]
[TR]
[TD]Oct[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]280[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]8.4[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD]B[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]320[/TD]
[TD="align: right"]3%[/TD]
[TD="align: right"]9.6[/TD]
[/TR]
</tbody>[/TABLE]

I'd like to create a 2D pivot that would show products as rows, and months as columns for sales revenue only, whereas the discount amount will be shown as total only.

Currently, Excel gives monthly breakdown for both sales revenue and discount amount; see example below:

I can simply hide the unnecessary columns, but this solution is not neat, and I will have other calculations with totals, so for each of them a 12 month break-down will be created.

Is there a way of achieving this results with standard pivot functionality?