View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
matchorno matchorno is offline
external usenet poster
 
Posts: 3
Default Pivot Table: use a field in two different places

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!!