pivot tables and standard deviations

[excelhatesme]

I have no problem creating a pivot table with three sets of data but when i try to get it to give me the standard deviation or average it just gives me an error #div/0!

What am i doing wrong?

 

[p45cal]

No idea. Attach a workbook perhaps.