Hi there, I have a Pivot Table in Excel2007 which I've made, however I was wondering if it is possible to add a calculated field or something like that which allows me to use the Grand Total and one of the Row fields........Basically the Row field has the total units I'm working with and the Grand Total is the amount which have issues to be addressed. I now need to show the % of issues. I've tried to just create a calculated field from the options, but it doesn't seem to be an option to use these fields and I was wondering if it's possible or if I'm wasting my time trying to figure it out. I'm not an expert in Excel, just self taught and learn as I go along but I'm a bit stumped. Any help would be greatly appreciated thanks