I've green on pivot tables and have a question.

Here is my data

Current Age Amount Offered Amount Bought
31 $500 $ 0
25 $600 $300
25 $900 $900
33 $200 $ 0
33 $900 $500
33 $200 $100

I would like to create a pivot based on the above data.

I'd like to show by age the average amount bought for those who did
buy.

So data should look like :

25 $600
33 $300 (not $200)
31 (shouldnt show up at all)

Thanks in advance.

-Brian