How to calculate "as %" of another unrelated column in a pivot?

[eroock]

Below you see a simplified version of my setup and how I envision the output. I am primarily looking to solve this with a pivot table and not with formulas. My problem is: How can I calculate the percentage of Value 2 from Value_1? I am using Excel 2007. Thanks

pivot_example.gif

[eroock]

Alright, I found the solution. The pivot calculation for Value_2 has to be changed from "count" to "average".
No idea, why it works, but it does.