Show part codes only whose have Book qty bal.in Pivot table

		Microsoft Office Forums > Microsoft Excel > Excel
Show part codes only whose have Book qty bal.in Pivot table

FAQ

Thread Tools

Display Modes

02-15-2012, 03:52 AM

pbengtss

Windows 7 64bit Show part codes only whose have Book qty bal.in Pivot table

Office 2010 32bit

Novice

Join Date: Feb 2012

Posts: 6

I attached a suggestion. Explenation:

1) In cell H5 in Sheet1, add formula "=SUMIF(B:B,B5,E:E)" and copy it to all cells in that column.

2) In the PivotTable Field List, move the field "Book Qty" to Row Labels (img01)

3) Right click a cell in column Book Qty, choose Filter->Label Filters... (img02)

4) Enter condition Greater than 0 (img03)

That's what you're looking for?

Attached Images

	img02.jpg (127.7 KB, 11 views)
	img01.jpg (32.5 KB, 10 views)
	img03.jpg (51.0 KB, 10 views)

Attached Files

Pivot Fixed.xlsx (16.2 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with pivot table macro	ejima	Excel Programming	2	02-16-2012 03:45 PM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM
pivot table design 2	dmonroe	Excel	2	11-15-2010 09:15 AM
Pivot Table Refresh	tpcervelo	Excel	0	09-14-2010 06:54 AM
Pivot Table's fields	janis129	Excel	7	03-02-2010 03:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 AM.