Thread
:
Averages With Zero In Pivot Tables
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
Posts: n/a
Averages With Zero In Pivot Tables
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(c20,"Yes","No")
Then drag down the column.
And use that field as a page field and only show the Yes's.
wrote:
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
Reply With Quote