ExcelBanter - sub totals

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sub totals (https://www.excelbanter.com/excel-discussion-misc-queries/68217-sub-totals.html)

flow23

sub totals

I have a pivottable in which there are sub totals

There are various data fields for which the sub total is displayed.

Is there a way, I can customise one of them? There is one field where I dont
want total but value of a particular cell. if thats not possible how can I
keep that field sub total blank?

All times are GMT +1. The time now is 05:19 PM.