#1
|
||||
|
||||
Show part codes only whose have Book qty bal.in Pivot table
I have a pivot table with so many part code with Sloc ( Storage Location ).It is possible that a part code who have book bal is zero in a location but have a book bal. in another location.
Now,I want to make a pivot table purely those parts who have book bal.more than zero in a location.Means part code who have not book bal.,should not appear in the pivot table.Is it possible? For more clarification,please refer attach sheet. Regards Pradeep Kumar Gupta |
#2
|
|||
|
|||
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? |
#3
|
||||
|
||||
Excellent answer and greatful to me.I am oblige.
Regards Pradeep |
Thread Tools | |
Display Modes | |
|
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 |