I've created a pivot table and I would like to use a formula which uses the 'total sum' and 'average ' figures, within the pivot table.
I've had a quick search on google and the only thing I can find is 'calculated figure', which I don't think will work as that will calculate the amounts on an line-by-line basis, when I'm only looking to calculate using the total figure.
Any advice would be very welcome
Thanks
Bookmarks