K
K. Georgiadis
A few weeks ago, I ended up with the perfect Pivot Table
layout by dragging fields around -- I just don't remember
how I got there!
I have attempted to create a similar table (with new
data) but, even though the field layout buttons are in
the exact same locations, the table looks different. I'm
trying to get "Sum of 2004", "Sum of 2005," etc. as
column headings across the top instead of having all
years one below the other.
Is there any way to copy the layout from the "perfect"
table to the new one?
layout by dragging fields around -- I just don't remember
how I got there!
I have attempted to create a similar table (with new
data) but, even though the field layout buttons are in
the exact same locations, the table looks different. I'm
trying to get "Sum of 2004", "Sum of 2005," etc. as
column headings across the top instead of having all
years one below the other.
Is there any way to copy the layout from the "perfect"
table to the new one?