| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot report - Hide Sums equal to zero
try adding an extra column to the data which contains a label of 'hide' or display' where that value is determined by using a sumif calculation so that if the sum of all trx values for a project is zero then it gets a label of 'hide' else 'display'. Then in the pivot table put the 'hide/display' label in the Page area and select only 'Display'. Formula would look like assuming the column headings were in row A ... '=IF(SUMIF($A$2:$A$100 [the list of projects],$A$2:$A$100 [the list of projects],$B$2:$B$100 [values for each project])=0,"Hide","Display") ... it worked when I tested it :-) -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=514160 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming Pivot Table Paramater Report | Excel Discussion (Misc queries) | |||
| Pivot Table Report Parameters to be named and saved like 'View' na | Excel Discussion (Misc queries) | |||
| How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
| Pivot table report | Excel Worksheet Functions | |||
| How do I manipulate pivot table report to include percentage of? | Excel Discussion (Misc queries) | |||
Threaded Mode
