J
JeffC
Hi, I have a pivot table with payroll information. Right now weeks go across
the top (column headings), and employees down the left (row headings). In
the data area, I have two fields: sum of hours, and sum of gross pay. These
two fields are being grouped in columns (i.e., each week now spans two
columns... one for hours, one for pay.) I want to change the layout such
that the two data items become two rows (i.e., each employee now spans two
rows, one for hours, one for gross pay - but only one column for each week).
In previous versions of excel I remember being able to do this... but I
haven't worked with pivot tables in a while and I now have Excel 2007.
Thanks in advance and I hope my description is clear enough.
(Windows XP, Excel 2007)
the top (column headings), and employees down the left (row headings). In
the data area, I have two fields: sum of hours, and sum of gross pay. These
two fields are being grouped in columns (i.e., each week now spans two
columns... one for hours, one for pay.) I want to change the layout such
that the two data items become two rows (i.e., each employee now spans two
rows, one for hours, one for gross pay - but only one column for each week).
In previous versions of excel I remember being able to do this... but I
haven't worked with pivot tables in a while and I now have Excel 2007.
Thanks in advance and I hope my description is clear enough.
(Windows XP, Excel 2007)