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)
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%
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.
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
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
