I am trying to learn how to retain calculated field settings in a Pivot Table. I have a pivot table with a huge amount of data and have inserted calculated fields to show the % yearly change, % monthly change etc. I have formatted these as a '% of difference from year previous' etc through the value field settings option, however when I 'Pivot' the table I lose this formatting and the figures are just displayed as the yearly/monthly total. I have checked the 'preserve formatting' box and trawled through forums but can't find a solution. Can anyone help please?