Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table
How do I set up additional data fields f.e. average sale and minimum sale
with sales field as source in pivot tables? |
#2
|
|||
|
|||
Hi
Pull in the same field - in your case sales- to the data section again. Double click on it and change to average. Pull the same field again , double click on it and change to min etc. -----Original Message----- How do I set up additional data fields f.e. average sale and minimum sale with sales field as source in pivot tables? . |
#3
|
|||
|
|||
Hi,
But how do I add these as rows right to the sales row (this was done in a microsoft example), so that I can get a good overwview? "akk" wrote: Hi Pull in the same field - in your case sales- to the data section again. Double click on it and change to average. Pull the same field again , double click on it and change to min etc. -----Original Message----- How do I set up additional data fields f.e. average sale and minimum sale with sales field as source in pivot tables? . |
#4
|
|||
|
|||
To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'. There are instructions with pictures he http://www.contextures.com/xlPivot02.html naturalnewzealand wrote: Hi, But how do I add these as rows right to the sales row (this was done in a microsoft example), so that I can get a good overwview? "akk" wrote: Hi Pull in the same field - in your case sales- to the data section again. Double click on it and change to average. Pull the same field again , double click on it and change to min etc. -----Original Message----- How do I set up additional data fields f.e. average sale and minimum sale with sales field as source in pivot tables? . -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |