Pivot table column for the average of a number of columns

[Hattie]

Pivot table column for the average of a number of columns in the PT

i have a pivot table

Col A - description
Col b to G - qty (number)
Col H - is the GRAND TOTAL

All I want to do is add a column after the GRAND TOTAL showing the average of the QTY columns.
in the first column after (outside) the pivot table.

If i just enter the formula =average(b20:g20) into the next cell I20
it works until i widen the date range and more columns are added to the pivot table.
the GRAND TOTAL is now in column K - as you would expect.
but then the averages column gets overwritten.

I have tried adding a calculated field with the average formula in it (it has the getpivotable data reference in it for the cells)
to just the last column of the pivot table.
but i get columns after all the data columns.

i have tried making a second count of the qty in the Sigma field and tried different settings in the value field settings.

but i just want one column at the end of the pivot table not lots of columns inside the table.

could someone point me in the right direction please

I'm sure its a simple thing once you know how.

thank you.

 

[GlennUK]

Put your calc to the left of the PivotTable instead of to the right.