Hi guys!

I have a question I cant get sorted out. I am preparing a new report for the business using different and more accurate data source and I would like to set up the file in a way that every month I can just copy new data and refresh the Pivots, avoiding any manual calculations outside Pivot table.

I would like to set up a calculated field, and I know how to set them up, but I dont know if it is possible to calculate % from 2 colums that have the same values (comes from one column in data range). I dont know if that would be the correct explanation.

Please see Image attached (I have blurred out parts due to confidentiality)

9-19-2012 5-22-32 PM.jpg

If this is not enaught, please let me know and I will set up a sample file.

I would appreciate any feedback on this!

Thank you in advance!

Artis89