Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Filter pivot table results without filtering in SQL query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neall - 27 Nov 2007 15:03 GMT
I have a pivot table setup witht he results I need,however I need to only see
those results that are of a specific age (15 days of older, 30 days or older
etc).  Is there a way to filter my results so they show only that relevant
age data by a drop option, so I can always use the same pivot table.

Thanks
Signature

Neall

Mike H. - 27 Nov 2007 16:33 GMT
If I am understanding your question, I think if you add another column to
your data that is a calculated formula that returns the age in the breakdowns
you wish to have.  Then you'll have to modify the pivottable to take that
extra column into account and then just use it in the upper left-corner of
your layout so you can view data for the various criteria.  HTH...

> I have a pivot table setup witht he results I need,however I need to only see
> those results that are of a specific age (15 days of older, 30 days or older
> etc).  Is there a way to filter my results so they show only that relevant
> age data by a drop option, so I can always use the same pivot table.
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.