pivot tables that combine several data tabs

[lj]

Hi, I'm trying to create a pivot table that combines several pages of
data that groups the data based on date and geography. I'm able to
get the pivot table put together and grouped correctly, but am having
problems getting the data into a layout that will work well for me.
"Geography" is the first column (farthest left) on the report and the
pvt table automatically separates it from the other data points.
"Date" is second, but "date" is grouped with the other datapoints and
I'm not able to separate it.

What I would like to have is "Geography" as my report filter (which I
can do now by moving it), "Date" as my row labels, and everything else
in the middle as values. How do I get "date" out of the same group as
the rest of my data, which is all called "collum" in the pvt table.
This is driving me crazy! Thanks.

Lisa

 

[Roger Govier]

Hi Lisa

Multiple Consolidation in PT's does not work in quite the way you would
expect.
It may be possible to achieve what you want, but I am having difficulty in
visualising your data, and it is difficult to describe it accurately.
If you would like to send me a small sample of your data and a note on what
you want to see, I will try and come up with a solution.

To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address

 

[Michael.Tarnowski]

Hi, I'm trying to create a pivot table that combines several pages of
data that groups the data based on date and geography. I'm able to
get the pivot table put together and grouped correctly, but am having
problems getting the data into a layout that will work well for me.
"Geography" is the first column (farthest left) on the report and the
pvt table automatically separates it from the other data points.
"Date" is second, but "date" is grouped with the other datapoints and
I'm not able to separate it.

What I would like to have is "Geography" as my report filter (which I
can do now by moving it), "Date" as my row labels, and everything else
in the middle as values. How do I get "date" out of the same group as
the rest of my data, which is all called "collum" in the pvt table.
This is driving me crazy! Thanks.

Lisa

Hi Lisa,
have a look at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;142589
http://www.contextures.com/xlPivot08.html
http://members.chello.nl/jvolk/keepitcool/files/MultiRangePivot.zip

maybe you will find answers there.
Have a nice day
Michael