Filtering the Value field in a Pivot Table

[katiapro93]

I give up! For the past few hours, I have been trying to figure out how do I filter the value field in a pivot table. I have a pivot table which gives me all the clients who purchased different items. I have placed the product in the column field and filtered it by the product that I want. Now I need to just show the ones who meet a certain number.
For Example: (Any client who buys 5 or more qualifies)

Client Product Qty
12 7oz 5
14 12oz 5
11 7oz 1

Report should show only the ones with Qty 5

Can anyone help me filter the Value field?

 

[tjgrassi]

Is there anyway to filter the values in excel 2010?

 

[RoryA]

It's the same steps as above - are you having an issue with them?

 

[tjgrassi]

I right clicked on the percent waste column (which are my vaules) and I have no option to filter.

 

[RoryA]

You need to right-click one of the row fields - not the data field - and apply a value filter to that using the percent waste field.

 

[tjgrassi]

This is what I had orginally thought, however when use the filter on either of my row fields and say percent waste greater than 10% it still shows values less than 10%

 

[RoryA]

Can you show us what your pivot table looks like?

 

[tjgrassi]

i'm not sure how I would be able to post that on here?

 

[RoryA]

You can either put the file on a sharing site like OneDrive/DropBox and post a link here, or there's a link to an add-in in my signature that allows you to select a range in a worksheet and copy it to the clipboard as HTML or BB Code, which you can then paste into a post here.

 

[tjgrassi]

	A​	B​	C​	D​	E​
2​	Date	BRAND	PRESS	PAPERSIZE	TOTALWASTE %
3​	wk1	ACSNC35	43​	35.5​	0.451​
4​	wk1	IRSCB30	45​	41.5​	0.024​
5​	wk1	IRSCB30	48​	42​	0.0412​
6​	wk1	RSGL45	43​	55.5​	0.1058​
7​	wk1	RSSNC30	43​	34.5​	0.0491​
8​	wk1	RSSNC30	43​	55.37​	0.064​
9​	wk1	RSSNC30	45​	34.5​	0.0172​
10​	wk1	RSSNC30	45​	41.5​	0.0255​
11​	wk1	RSSNC30	46​	55.37​	0.043​
12​	wk1	RSSNC30	46​	62.25​	0.0298​
13​	wk1	RSSNC30	46​	62.75​	0.0324​
14​	wk1	RSSNC30	47​	34.5​	0.0315​
15​	wk1	RSSNC30	47​	35​	0.1097​
16​	wk1	RSSNC30	48​	34.5​	0.0427​
17​	wk1	RSSNC30	48​	35​	0.0362​
18​	wk1	RSSNC30	48​	41.5​	0.0286​
19​	wk1	RSSNC30	48​	42​	0.0415​
20​	wk1	RSSNC35	43​	53.25​	0.1184​

This is the data, i think i did this right, once you mkae a pivot chart press goes in report filter, and filter to 43, papersize goes in to column labes. then date and brand goes in to row, with date on top and then total waste in values

 

[tjgrassi]

So i've noticed that it will filter some when i try to do greater than .1 but it doesn't filter everything less than .1 out. I noticed this when i did the extreme case of .5. there was only one data point with this, however the .55 point was ther but then there were a few points that were 11 other points still on the graph all less than .1. I'm not sure why this would happen.