| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
Do you need to do this in a pivot table? Perhaps it would be easier to
use an AutoFilter in the source data, where you could use a custom filter to view records in that range. Jan wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
Thanks for your quick reply.
Yes it has to be in the pivottable. I'm aware of the autofiler, but it doesn't fully suit my purpose. The users will then have to swap between the pivot-table and the data, which is not so convenient. But it doesn't sound on you like there is a 'standard' function for this? "Debra Dalgleish" wrote: Do you need to do this in a pivot table? Perhaps it would be easier to use an AutoFilter in the source data, where you could use a custom filter to view records in that range. Jan wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
In Excel 2007 you could filter the row field for a range of ages. In
earlier versions that feature isn't available. If you don't have Excel 2007, and you don't want to use the check boxes, perhaps you could use programming to allow users to enter an age range in cells on the worksheet, then the macro would change the pivot table. Jan wrote: Thanks for your quick reply. Yes it has to be in the pivottable. I'm aware of the autofiler, but it doesn't fully suit my purpose. The users will then have to swap between the pivot-table and the data, which is not so convenient. But it doesn't sound on you like there is a 'standard' function for this? "Debra Dalgleish" wrote: Do you need to do this in a pivot table? Perhaps it would be easier to use an AutoFilter in the source data, where you could use a custom filter to view records in that range. Jan wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
OK, sounds like it's time for an upgrade then ;-)
Once again thanks very much for your quick answer. "Debra Dalgleish" wrote: In Excel 2007 you could filter the row field for a range of ages. In earlier versions that feature isn't available. If you don't have Excel 2007, and you don't want to use the check boxes, perhaps you could use programming to allow users to enter an age range in cells on the worksheet, then the macro would change the pivot table. Jan wrote: Thanks for your quick reply. Yes it has to be in the pivottable. I'm aware of the autofiler, but it doesn't fully suit my purpose. The users will then have to swap between the pivot-table and the data, which is not so convenient. But it doesn't sound on you like there is a 'standard' function for this? "Debra Dalgleish" wrote: Do you need to do this in a pivot table? Perhaps it would be easier to use an AutoFilter in the source data, where you could use a custom filter to view records in that range. Jan wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
You're welcome! Enjoy the upgrade.
Jan wrote: OK, sounds like it's time for an upgrade then ;-) Once again thanks very much for your quick answer. "Debra Dalgleish" wrote: In Excel 2007 you could filter the row field for a range of ages. In earlier versions that feature isn't available. If you don't have Excel 2007, and you don't want to use the check boxes, perhaps you could use programming to allow users to enter an age range in cells on the worksheet, then the macro would change the pivot table. Jan wrote: Thanks for your quick reply. Yes it has to be in the pivottable. I'm aware of the autofiler, but it doesn't fully suit my purpose. The users will then have to swap between the pivot-table and the data, which is not so convenient. But it doesn't sound on you like there is a 'standard' function for this? "Debra Dalgleish" wrote: Do you need to do this in a pivot table? Perhaps it would be easier to use an AutoFilter in the source data, where you could use a custom filter to view records in that range. Jan wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivottable
Hi Jan,
In Excel 2003, you could enter the range 5 to 8 in separate worksheet cells, then use a helper column next to the original data with a simple If statement to group the values into the range. I have set up a sample worksheet here; http://www.edferrero.com/SelectingRa...ivotTables.zip Ed Ferrero www.edferrero.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable and Chart | Excel Discussion (Misc queries) | |||
| Excel 2007 PivotTable and Chart | Excel Discussion (Misc queries) | |||
| QUESTION: Copy pivottable from excel file to another. | Excel Discussion (Misc queries) | |||
| Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
| Sorting in PivotTable | Excel Discussion (Misc queries) | |||
Linear Mode
