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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:09 PM.