Averages With Zero In Pivot Tables

[bdaoust]

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

 

[Dave Peterson]

If you cleared that 0 (left the cell empty) or even put None or N/A in that
cell, you'd get the value you want.

An alternative...

Add another column that shows Y/N if they bought or not.

=if(c2>0,"Yes","No")

Then drag down the column.

And use that field as a page field and only show the Yes's.