Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "drop page fileds here" for in a pivot table?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "drop page fileds here" for in a pivot table?
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) "pgarcia" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is "drop page fileds here" for in a pivot table?
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. pgarcia wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to hide "All" in drop-down menu of my pivot table | Excel Discussion (Misc queries) | |||
Link "page-by" drop-down in two pivot tables | Excel Worksheet Functions | |||
Don't want the "All" option in the Drop Page Field of a pivot tabl | Excel Discussion (Misc queries) |