Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default Filter pivot table results without filtering in SQL query

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
--
Neall
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 471
Default Filter pivot table results without filtering in SQL query

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...

"Neall" wrote:

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
--
Neall

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering within Pivot Table HeatherJ Excel Discussion (Misc queries) 1 February 12th 10 07:08 PM
filtering dates in a Pivot Table Report Filter jsmith Excel Discussion (Misc queries) 3 November 11th 09 03:27 AM
filtering the pivot table..! via135 Excel Discussion (Misc queries) 1 August 6th 08 08:20 PM
VBA - query an Access table - results in Excel rirus Excel Programming 3 August 21st 06 07:29 PM
Query Table - weird results sandeep[_2_] Excel Programming 1 October 9th 03 06:40 AM


All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"