CRISTINA1128
New Member
- Joined
- Jun 21, 2016
- Messages
- 9
Hello, I am using EXCEL 2016. I have my Pivot Table and only want to see values greater than zero. When I use value filter (in the pivot table) and select "value filters" then "greater than" and enter the number "1", I'm still seeing values "DIV/0!". Can anyone tell me why?
[TABLE="width: 1056"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]BRAND[/TD]
[TD]STYLE[/TD]
[TD]CUSTOMER[/TD]
[TD]Sum of WHLSL COST (P&O)[/TD]
[TD]Sum of PICK & OPEN QTY[/TD]
[TD]Sum of PICK & OPEN $$[/TD]
[/TR]
[TR]
[TD]BEBE[/TD]
[TD]ABELLA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$30.95[/TD]
[TD="align: right"]1,662[/TD]
[TD="align: right"]$51,439[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ADISONN[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$49.80[/TD]
[TD="align: right"]1,920[/TD]
[TD="align: right"]$95,616[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ALBAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$45.95[/TD]
[TD="align: right"]962[/TD]
[TD="align: right"]$44,204[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ALYSON[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$32.70[/TD]
[TD="align: right"]1,052[/TD]
[TD="align: right"]$34,400[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]FIONAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$38.00[/TD]
[TD="align: right"]2,157[/TD]
[TD="align: right"]$81,966[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]HONEYCOMB[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$13.15[/TD]
[TD="align: right"]1,425[/TD]
[TD="align: right"]$18,739[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ILANA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$9.04[/TD]
[TD="align: right"]5,341[/TD]
[TD="align: right"]$48,308[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BURLINGTON[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]IRINAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$36.25[/TD]
[TD="align: right"]1,912[/TD]
[TD="align: right"]$69,310[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]KAYLEY[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$37.45[/TD]
[TD="align: right"]1,091[/TD]
[TD="align: right"]$40,858[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance!
[TABLE="width: 1056"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]BRAND[/TD]
[TD]STYLE[/TD]
[TD]CUSTOMER[/TD]
[TD]Sum of WHLSL COST (P&O)[/TD]
[TD]Sum of PICK & OPEN QTY[/TD]
[TD]Sum of PICK & OPEN $$[/TD]
[/TR]
[TR]
[TD]BEBE[/TD]
[TD]ABELLA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$30.95[/TD]
[TD="align: right"]1,662[/TD]
[TD="align: right"]$51,439[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ADISONN[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$49.80[/TD]
[TD="align: right"]1,920[/TD]
[TD="align: right"]$95,616[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ALBAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$45.95[/TD]
[TD="align: right"]962[/TD]
[TD="align: right"]$44,204[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ALYSON[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$32.70[/TD]
[TD="align: right"]1,052[/TD]
[TD="align: right"]$34,400[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]FIONAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$38.00[/TD]
[TD="align: right"]2,157[/TD]
[TD="align: right"]$81,966[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]HONEYCOMB[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$13.15[/TD]
[TD="align: right"]1,425[/TD]
[TD="align: right"]$18,739[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]ILANA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$9.04[/TD]
[TD="align: right"]5,341[/TD]
[TD="align: right"]$48,308[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]BURLINGTON[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]IRINAA[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$36.25[/TD]
[TD="align: right"]1,912[/TD]
[TD="align: right"]$69,310[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]KAYLEY[/TD]
[TD]BEBE[/TD]
[TD="align: right"]$37.45[/TD]
[TD="align: right"]1,091[/TD]
[TD="align: right"]$40,858[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance!