Pivot Table - filter data values

[vpxlquest]

I am using Excel 2003 and working with Pivot tables.


I have constructed a pivot table showing the sales values with all ranges and one for values >100,000. The source data is the same but the data is filtered in one and not in another.

is there anyway i can use the same source data and have the pivot table show all values and sales values >100,000. I dont seem to see any option were we can filter the value data. Am i missing something!!


Thanks for reading this post.

 

[Luke M]

In your source data, you could have a helper column with formula:

=D2>100000


Label the column appropriately, maybe "LARGE VALUE"


Refresh the PivotTable (making sure your helper column is included in data range) then add the LARGE VALUE field to the Page_area. Now you can do a quick toggle between TRUE/FALSE/ALL

 

[vpxlquest]

Perfect that worked out great!! Thanks a ton.

 

[amit01024]

Filter Pivot Table by Values in Data column in Excel


Visit : http://www.excelolozy.com/2011/08/tip-filter-pivot-table-by-values-in.html


EDITED by SirJB7 on 27/08/2012 (check below post for clarification)

 

[Debraj]

Hi Amit,


Thank you joining the forum... and Thanks a lot for sharing such a great site..

I will personally want to endorse you, to my companies Marketing Team..


Regards,

Deb

 

[SirJB7]

@amit01024

Hi!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


1) If you're gonna asking questions, among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


2) Now, if you're gonna posting solutions (which we all encourage you to do), well I see that you've posted at two topics (this one and here http://chandoo.org/forums/topic/to-know-horizontal-filter-with-set-filter-button#post-38849) and in both cases you posted solutions from other sites. Thing perfectly accepted and well seen, specially for giving credit to the author.


But what I found shocking and disgusting are the same exact phrase following the related links link (which is actually the site's motto) and the last link itself: this is not the place to advertise and propagandize for other websites, either about Excel or any other subject. So please refrain form adding such intentional unnecessary extras to your posts or they will be treated as spam. And here we don't like spam, not even a little.


I've edited this 2nd reference.


Regards!