I've created a pivot table of information that will track golf outing invitees and counts. At present the fields - Day, Name, Company, Team are in the row area, and I am counting names.
My boss wants to rearrange the information in more of a grid. With Days along the left and Teams across the top. Undereach team, he wants to show the Name and Company of attendee.
I am trying to put the Day in the Row area. Have put Team in the Column area. But I can't seem to create "sub" columns, so to speak.
If I put Count Names in the Data area, that will help me count how many invitees per team, per day.
How can I get the invitee names UNDERNEATH their team column heading?
My boss wants to rearrange the information in more of a grid. With Days along the left and Teams across the top. Undereach team, he wants to show the Name and Company of attendee.
I am trying to put the Day in the Row area. Have put Team in the Column area. But I can't seem to create "sub" columns, so to speak.
If I put Count Names in the Data area, that will help me count how many invitees per team, per day.
How can I get the invitee names UNDERNEATH their team column heading?
