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