Hi,

I know I might need to put this formula outside of the pivot table after trying different ways but does anyone know of a way I can insert a calculated field to divide a number by the Grand Total and then multiple by a figure:
For example:

Name: Amount: Formula:
A £10 (=£10/£37)*£5 = £1.35
B £5 (=£5/£37) * £5 = £0.67
C £3 etc
D £8 etc
E £11 etc.......
Grand Total £37

Thanks