LinkBack URL
About LinkBacks
Hi, After defining new calculated field in a pivot table (column D, It's a simple model), I'd like to filter out cities with less than 2,000 residents. How do I do it through my current P-Table?
Hi, After defining new calculated field in a pivot table (column D, It's a simple model), I'd like to filter out cities with less than 2,000 residents. How do I do it through my current P-Table?
Add a Value based filter to your Row Label field based on residents field - ie where Sum of Residents >= 2000.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
DonkeyOte,
a) To where do I add this filter, to the relevant row in the original databse or in the Pivot's produced table?
b) Where exactly the filter should be put?
Right click on "A" in Row Field and choose Filter -> Value Filter and set the criteria.
Brilliant. Thanks. So generally any cell in the left column of the a pivot table enables filtering?
One more thing. When I switched from the sample back to my rather big P-table, it contains 205 cities, the tool enabled me to filter only "top 10". Does it have to do with the number of my rows?
No, you can also use e.g. 15 items.
See the attached file, where I choosed for 15 items (lowest).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I see, it's just that the "top 10" thing is confusing because actually any number, not only up to 10, could be chosen to be shown as well. Thanks again!
Glad I could help.
Yes, the title top"10" is confusing, but now you know, it wouldn't be a problem for you anymore.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks