Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
Hi Sorry about coming back again, but I have a question about page fields.
Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
You can drag the page field temporarily to the Row area, select the
items you want, then drag it back to the Page area. Or, double-click on the Page field button, and in the Hide Items list, click on items to hide. Click on hidden items to show them again. Sharon wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
Nope. You can not multi select unless the pivot is based on an OLAP cube. The
work around is to build a dynamic heirarchy structure into your source data. It is a real pain to do though and requires refreshing the pivot each time the hierarchy is changed... -- HTH... Jim Thomlinson "Sharon" wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
Thanks a lot Debra and Jim - thought as much - no easy way to do it!!
Thanks again for taking the time to reply. REgards -- Sharon "Jim Thomlinson" wrote: Nope. You can not multi select unless the pivot is based on an OLAP cube. The work around is to build a dynamic heirarchy structure into your source data. It is a real pain to do though and requires refreshing the pivot each time the hierarchy is changed... -- HTH... Jim Thomlinson "Sharon" wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
what's not easy about Debra's method. I use it all the time.
-- Regards, Tom Ogilvy "Sharon" wrote: Thanks a lot Debra and Jim - thought as much - no easy way to do it!! Thanks again for taking the time to reply. REgards -- Sharon "Jim Thomlinson" wrote: Nope. You can not multi select unless the pivot is based on an OLAP cube. The work around is to build a dynamic heirarchy structure into your source data. It is a real pain to do though and requires refreshing the pivot each time the hierarchy is changed... -- HTH... Jim Thomlinson "Sharon" wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
I'm not sure about programatically doing this but there is a manual way to do this. If you drag your page field down to the rows section as the first field you can click the select arrow, check or uncheck the items you want or don't want and then drag the field back up to the page section. The pivot will now be based on your multiple selections. Sharon Wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=566060 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
Oddly enough I agree with Tom. Debrah's method is very easy to do. I too use
that method all of the time. (I did not know that you could just double click though. I always right clicked and selected Field Settings. You learn something new every day.). The method I described I implimented in that past (through code) to allow selections more similar to the multi select from an OLAP cube as the users wanted to be able to select and deselect blocks of members based on a heirarchy structure. It is a pain to do but it works... -- HTH... Jim Thomlinson "Tom Ogilvy" wrote: what's not easy about Debra's method. I use it all the time. -- Regards, Tom Ogilvy "Sharon" wrote: Thanks a lot Debra and Jim - thought as much - no easy way to do it!! Thanks again for taking the time to reply. REgards -- Sharon "Jim Thomlinson" wrote: Nope. You can not multi select unless the pivot is based on an OLAP cube. The work around is to build a dynamic heirarchy structure into your source data. It is a real pain to do though and requires refreshing the pivot each time the hierarchy is changed... -- HTH... Jim Thomlinson "Sharon" wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
I meant the drag to a row field. I use that. I didn't know about the double
click. However, having tried it, I would have to say the answer to the OP's original question is YES for manually. -- Regards, Tom Ogilvy "Jim Thomlinson" wrote: Oddly enough I agree with Tom. Debrah's method is very easy to do. I too use that method all of the time. (I did not know that you could just double click though. I always right clicked and selected Field Settings. You learn something new every day.). The method I described I implimented in that past (through code) to allow selections more similar to the multi select from an OLAP cube as the users wanted to be able to select and deselect blocks of members based on a heirarchy structure. It is a pain to do but it works... -- HTH... Jim Thomlinson "Tom Ogilvy" wrote: what's not easy about Debra's method. I use it all the time. -- Regards, Tom Ogilvy "Sharon" wrote: Thanks a lot Debra and Jim - thought as much - no easy way to do it!! Thanks again for taking the time to reply. REgards -- Sharon "Jim Thomlinson" wrote: Nope. You can not multi select unless the pivot is based on an OLAP cube. The work around is to build a dynamic heirarchy structure into your source data. It is a real pain to do though and requires refreshing the pivot each time the hierarchy is changed... -- HTH... Jim Thomlinson "Sharon" wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry - Pivots and Me Again!!
Hi All
I absolutely agree that Debra's way is really easy to do manually. However, I needed to do it programatically so I have found that hiding unwanted items is easier from a coding perspective. Many thanks to you all for your help (again!!) -- Sharon "Excelenator" wrote: I'm not sure about programatically doing this but there is a manual way to do this. If you drag your page field down to the rows section as the first field you can click the select arrow, check or uncheck the items you want or don't want and then drag the field back up to the page section. The pivot will now be based on your multiple selections. Sharon Wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Sharon -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=566060 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivots/Charts | Charts and Charting in Excel | |||
several pivots | Excel Discussion (Misc queries) | |||
Pivots | Excel Programming | |||
I would like to build macro's to do pivots or part of pivots | Excel Programming | |||
Pivots using other pivots and dynamic query problem | Excel Programming |