Pivot tables- putting more than two field list item into the data

D

Driver

Hello

I am trying to put more than two fields into the data area. Firstly I
dropped one field into the data area, then I dropped another field right on
top of where it says "data" with the drop down item. When I try and drop
further fields into onto the data area they end up either in the column or
row fields. How do I get around this?

Thankyou in advance

Driver/Tim
 
D

Debra Dalgleish

When you're dragging the field onto the pivot table, look at the pivot
table symbol on the pointer. A blue area will appear, showing where the
field will be placed when you release the mouse button. If the symbol is
blue near the top, you're over the column area. If it has a blue square
at the bottom right, you're over the data area.

Drop the new fields into the area where the numbers are showing, and
they should end up in the Data area.
 
D

Driver

Thank you

Debra Dalgleish said:
When you're dragging the field onto the pivot table, look at the pivot
table symbol on the pointer. A blue area will appear, showing where the
field will be placed when you release the mouse button. If the symbol is
blue near the top, you're over the column area. If it has a blue square
at the bottom right, you're over the data area.

Drop the new fields into the area where the numbers are showing, and
they should end up in the Data area.
 
Top