What is "drop page fileds here" for in a pivot table?

P

pgarcia

What is "drop page fileds here" for in a pivot table? Can I add a header? I
have three pivot table on one sheet and I need to tell which tabel is which.
I need header but one that will move with the table.

Thanks
 
S

Sean Timmons

When you create a pivot table, you take one column of data and put in down
rows (row fields) and another column of data across columns (column fields).
then, you take a third column (usually numbers) and drop it into Data fields
to get sum, average, etc.

The header for Data will show on the top left. you can rename this button to
whatever you'd like (except the field name itself)
 
D

Debra Dalgleish

The Page area of a pivot table acts as a filter. For example, if you
drop a Region field there, you could select a specific region from that
dropdown. Then the pivot table would only show the results for that region.

There's a blank row between the last page field and the body of the
pivot table. You could type a heading there.
 
Top