Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Two related questions:
1. Is there anyway to display a field in two different places. For example, I want to put a date field in the page part of pivot table. However, I also want that same date field in the row area. So when I choose "all" dates on the page filter, I will be able to see the individual dates in the row as well. Right now when I try to add the field, it takes it out of where it used to be. i.e., when I add to the page, the row field disappears. 2. I want to group dates by month. But I also want to display the individual dates in the row area right next to it. So it would look like the following: January 1/2/10 Joe Smith 1/5/10 Dennis Johnson 1/15/10 blah, blah, blah February 2/1/10 Insert name here 2/3/10 another name However I have the same problem as number 1, I can only use the date field once. Any help is greatly appreciated!! Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
Excell 2007 Pivot Table Calculation changes decimal places | Excel Worksheet Functions | |||
sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) |