Pivot table layout

G

Guest

Hi,

I have a simple pivot table with categories of beverages in the row field
and the number of units sold for each category in 2004 in the data area. I
want to add unit sales for 2005 and for 2006 to the data area, but I want the
data for these years to show up to the right of the data for 2004, not
underneath it in the same column.

Thanks,
Paul
 
R

Roger Govier

Hi Paul

Grab the field label for Sum of data, and drag it to the Total column on
the PT.
That will bring the relevant year's data side by side.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering credits in a Pivot Table 3
Pivot Table Values as a % of a Subtotal 1
pivot table excel 2
Calculated Field 2
re-using pivot table layout 1
Pivot table organizing 2
Pivot Table criteria 2
Pivot table data layout - columns to rows 1

Top