Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default Pivottable

Hi,

Is it possible to select a range in the output of a pivot-table?

A simple example:
Name Age Town
John 5 Copenhagen
Doe 6 Vienna
Rob 10 Budapest
Deb 8 Vienna

In the pivottable I would like to select the range of persons 5 to 8 years
old. And not by selecting each year in the drop-down. Is this possible?

Any response appreciated. Also let me know if I need to clarify, thanks.

 
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
PivotTable and Chart Michael Excel Discussion (Misc queries) 0 August 3rd 06 06:57 PM
Excel 2007 PivotTable and Chart Michael Excel Discussion (Misc queries) 0 June 27th 06 09:31 PM
QUESTION: Copy pivottable from excel file to another. Simon Excel Discussion (Misc queries) 0 April 26th 06 10:48 AM
Dynamic parameterized PivotTable update? Nick Keller Excel Discussion (Misc queries) 0 February 24th 06 11:02 PM
Sorting in PivotTable Aaron Howe Excel Discussion (Misc queries) 5 July 12th 05 09:49 PM


All times are GMT +1. The time now is 12:05 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"