I've attached a spreadhseet here - it's only the pivot table tab I'm concerned with. The table in pink to the right of the pivot table is showing percentages of various values shown by the table. When I apply any filters to the pivot, the 'progress' table does not follow the filter and comes up with #ref!

Is there a way I can link the percentage calculations I need with the pivot table so that when the pivot is filtered the percentages I need change to reflect the new data correctly?

Hopefully I've explained that just well enough so you can see what I mean! I cannot tell you how helpful knowing this would be.

PiXL Master KS4 ELPeg.xls