Pivot table

[naturalnewzealand]

How do I set up additional data fields f.e. average sale and minimum sale
with sales field as source in pivot tables?

 

[akk]

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.

 

[naturalnewzealand]

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?

 

[Debra Dalgleish]

To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'.

There are instructions with pictures here:

http://www.contextures.com/xlPivot02.html