Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to eliminate xero values from pivot table and list top 10 only
I am using Pivot table's advance function to select "top 10" choosing
variance Up/(Down) as selective field for top 10 and gives me more than 10 customer listing as well as zero values. How can I eliminate zero values out of Pivot table and secondly why it is listing more than 10 customer listing? Data Region Customer Name Feb Jan Variance Up / (Down) Dublin Charles Taylor Consulting Plc 11,791 - 11,791 ABN AMRO Bank NV 94,494 84,736 9,758 Cap Gemini UK Plc 11,968 11,785 183 Vauxhall Motors Ltd 2,594 2,555 40 Telecity UK Ltd - - Synstar Computer Services (UK) Ltd - - - SKYNET SYSTEMS LTD - - - Siemens VDO Automotive Limited - - - Redstone Communications Limited - - - Nescot Corporation - - - Microsoft Ireland Operations Ltd - - - LAN Communications - - - GFI Informatics Limited - - - Erinaceous Group Plc - - - Easynet Group Plc - - - Comstor Ltd - - - Xpert Systems Ltd - - - Unisys Limited - - - Cablecom Networking Limited - - - BSW Timber Plc - - - Dublin Total 120,848 99,076 21,772 I am using Pivot table's advance function to select "top 10" choosing variance Up/(Down) as selective field for top 10 and gives me more than 10 customer listing as well as zero values. How can I eliminate zero values out of Pivot table and secondly why it is listing more than 10 customer listing? Dinesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table hanging on to deleted values | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Sort & Top List | Excel Discussion (Misc queries) | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |