| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Top 10 hide negatives values
Hi
I have created a Pivot table which has filtered customer data based on their growth from LY, Top 10 and Bottom 10. Becasue one category of customer 250 only has 10 customers and all of them are growing negatively this year on last year I would expect that they would not appear in the TOP 10, however because they are the only customers in this category it seems the pivot table wants them there. Is there anyway I can ask for a TOP 10 and have a condition saying do not show if has a negative growth? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can i hide parts of a Pivot tables subtotals??? | Excel Discussion (Misc queries) | |||
| Pivot Tables - Hide Zero Amount Rows In Office 2007 | Excel Discussion (Misc queries) | |||
| Pivot tables hide info drop down menu | Excel Worksheet Functions | |||
| hide zeros & negatives for date formulas | Excel Discussion (Misc queries) | |||
| Can I permanently delete/hide data within Pivot Tables? | Charts and Charting in Excel | |||
Linear Mode
