R
RLB
I am working on 10 different pivot tables and charts based on data that I
have imported through an access query in a database I use. I have been
changing around the feilds in different reports on a regular basis but when I
tried to use a different date feild than I originally had in the report it
suddenly gave me the message:
"A PivotTable report cannot overalp another PivotTable report"
This doesn't seem right, even when I remove all of the fields from the
report, it still gives me that error when i try to replace a new feild. When
I try to replace the original feild I took out it gives me the same message.
I only get this message with some of the fields.
I am not sure if there is a glitch or what. One thing worth mentioning that
I am not sure is related or not is that the original date field I have
grouped manually into two different feilds (year and quarter).
HELP!! Any advice or ideas that anyone can provide is appreciated!
Thanks!
have imported through an access query in a database I use. I have been
changing around the feilds in different reports on a regular basis but when I
tried to use a different date feild than I originally had in the report it
suddenly gave me the message:
"A PivotTable report cannot overalp another PivotTable report"
This doesn't seem right, even when I remove all of the fields from the
report, it still gives me that error when i try to replace a new feild. When
I try to replace the original feild I took out it gives me the same message.
I only get this message with some of the fields.
I am not sure if there is a glitch or what. One thing worth mentioning that
I am not sure is related or not is that the original date field I have
grouped manually into two different feilds (year and quarter).
HELP!! Any advice or ideas that anyone can provide is appreciated!
Thanks!