| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivottable to count non-zeros
Is there some way to get a pivottable to display a count of all non-zero entries? I'd want to use a pivottable over subtotaling or a combination of sorting and counta, due to the amount of categories I have to split items into (~approx 200). -- janssenchoy ------------------------------------------------------------------------ janssenchoy's Profile: http://www.excelforum.com/member.php...o&userid=32805 View this thread: http://www.excelforum.com/showthread...hreadid=526227 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable to count non-zeros
Maybe you could use a helper column:
=if(a2=0,0,1) and then include that in the pivottable as sum??? janssenchoy wrote: Is there some way to get a pivottable to display a count of all non-zero entries? I'd want to use a pivottable over subtotaling or a combination of sorting and counta, due to the amount of categories I have to split items into (~approx 200). -- janssenchoy ------------------------------------------------------------------------ janssenchoy's Profile: http://www.excelforum.com/member.php...o&userid=32805 View this thread: http://www.excelforum.com/showthread...hreadid=526227 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
| Why does my Excel pivottable uses count instead of sum | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| PivotTable Macro Reverts to Count Function | Excel Worksheet Functions | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
Hybrid Mode
