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 |
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) |