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

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