Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Pivot Table Question
Hi All,
Hopefully somebody knows the answer to this one, but I can't work it out. I'm using Excel 2007 and have created a pivot table that has location and name as row titles, e.g. London Tom Charles Harry Edward Bath Jane Roger etc There are also column titles and values but these aren't relevant to the question. The pivot table is displayed in tabular form, i.e. Location is a column to the left of Name. As you can see in the example above, each location is only listed once, adjacent to the first person within it. So the question is this - how can I get it to be listed against each person, e.g. London Tom London Charles London Harry London Edward Bath Jane Bath Roger etc I've looked around for ages and can't find a setting for this. All help appreciated, even if it's just telling me that it can't be done because at least then I'll know to stop trying! Cheers, Tom. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Pivot Table Question
I'm not 100% sure, but I would think it's not possible. What puzzles me is
why you want your PivotTable to look like that, as that format is the same layout of the raw data. Why go through the trouble of creating a PivotTable if you didn't actually want XL to group things? Continuing this line of thought, why did you want a repeated label? If you need it for a formula, I would suggest using the GETPIVOTDATA function, as it would prb work better. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mr-tom" wrote: Hi All, Hopefully somebody knows the answer to this one, but I can't work it out. I'm using Excel 2007 and have created a pivot table that has location and name as row titles, e.g. London Tom Charles Harry Edward Bath Jane Roger etc There are also column titles and values but these aren't relevant to the question. The pivot table is displayed in tabular form, i.e. Location is a column to the left of Name. As you can see in the example above, each location is only listed once, adjacent to the first person within it. So the question is this - how can I get it to be listed against each person, e.g. London Tom London Charles London Harry London Edward Bath Jane Bath Roger etc I've looked around for ages and can't find a setting for this. All help appreciated, even if it's just telling me that it can't be done because at least then I'll know to stop trying! Cheers, Tom. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick Pivot Table Question
Hi Luke,
Thanks for the reply. The pivot table is actually a query which simply returns to a pivot, allowing some more layout flexibility and aggregation. Unfortunately, my mandate is rather restricted - a poorly designed bit of MI has been created. I can't touch the output itself and as such simply have to work "between" the data source and the output. My mandate is to rip the guts out as nobody can understand them and to rebuild it simply. But without touching the source data or the destination... Any way, Why would I want it? Simply because on the "presentation" sheet, each person has their location adjacent to them and therefore if I'm going to pull it through from somewhere, it would help if each person was also adjacent to their location on the pivot table. But thanks for the reply, and if nobody comes up with a way of doing it, I'll take the answer as "no" and you get the tick! Cheers, Tom. "Luke M" wrote: I'm not 100% sure, but I would think it's not possible. What puzzles me is why you want your PivotTable to look like that, as that format is the same layout of the raw data. Why go through the trouble of creating a PivotTable if you didn't actually want XL to group things? Continuing this line of thought, why did you want a repeated label? If you need it for a formula, I would suggest using the GETPIVOTDATA function, as it would prb work better. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mr-tom" wrote: Hi All, Hopefully somebody knows the answer to this one, but I can't work it out. I'm using Excel 2007 and have created a pivot table that has location and name as row titles, e.g. London Tom Charles Harry Edward Bath Jane Roger etc There are also column titles and values but these aren't relevant to the question. The pivot table is displayed in tabular form, i.e. Location is a column to the left of Name. As you can see in the example above, each location is only listed once, adjacent to the first person within it. So the question is this - how can I get it to be listed against each person, e.g. London Tom London Charles London Harry London Edward Bath Jane Bath Roger etc I've looked around for ages and can't find a setting for this. All help appreciated, even if it's just telling me that it can't be done because at least then I'll know to stop trying! Cheers, Tom. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Quick pivot table question | Excel Discussion (Misc queries) | |||
Quick Question - Pivot Table Data | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) |