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? BRAND STYLE CUSTOMER Sum of WHLSL COST (P&O) Sum of PICK & OPEN QTY Sum of PICK & OPEN $$ BEBE ABELLA BEBE $30.95 1,662 $51,439 ADISONN BEBE $49.80 1,920 $95,616 ALBAA BEBE $45.95 962 $44,204 ALYSON BEBE $32.70 1,052 $34,400 FIONAA BEBE $38.00 2,157 $81,966 HONEYCOMB BEBE $13.15 1,425 $18,739 ILANA BEBE $9.04 5,341 $48,308 BURLINGTON #DIV/0! 0 $0 IRINAA BEBE $36.25 1,912 $69,310 KAYLEY BEBE $37.45 1,091 $40,858 Thanks in advance!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel 2016 - pivot table value filtering not working correctly

Thread starter CRISTINA1128
Start date Jun 21, 2016
Tags

div/0! excel 2016 excel 2016 pivot value filters

CRISTINA1128

New Member

Jun 21, 2016

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?

BRAND	STYLE	CUSTOMER	Sum of WHLSL COST (P&O)	Sum of PICK & OPEN QTY	Sum of PICK & OPEN $$
BEBE	ABELLA	BEBE	$30.95	1,662	$51,439
	ADISONN	BEBE	$49.80	1,920	$95,616
	ALBAA	BEBE	$45.95	962	$44,204
	ALYSON	BEBE	$32.70	1,052	$34,400
	FIONAA	BEBE	$38.00	2,157	$81,966
	HONEYCOMB	BEBE	$13.15	1,425	$18,739
	ILANA	BEBE	$9.04	5,341	$48,308
		BURLINGTON	#DIV/0!	0	$0
	IRINAA	BEBE	$36.25	1,912	$69,310
	KAYLEY	BEBE	$37.45	1,091	$40,858