On Mar 17, 6:46*pm, matchorno
wrote:
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!!

Good evening,

I suppose that you can change the data source of your pivot table.
To solve problem 1, my idea would be to add a new column to your data
with the same data as the column containing the date data.
For the 2nd problem, you can add a new column computing the month
corresponding to the date (look for the MONTH function)

Hope it helps

Regards