I have created a Pivot Report which works very nicely.

The only issue is the key data for the pivot must be placed as a total (unless I am missing a point) and as such there is no way of turning the section totals off.

The section totals mean nothing as each column is a combination of figures which doesn't and isn't supposed to add up.

I have turned on "Hide grand column total" and "Hide Grant Row Totals" both which make no difference as I assume they are associated to final totals not section totals.

I thought I would do an Extra column and key-figure calculation which doesn't appear to automatically total, but it doesn't seem to matter what formulae I put in there I don't get a result.

I am sure there must be a very simple answer as to how to do this?