Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages With Zero In Pivot Tables
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
averages in pivot tables | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |