Hi guys,
I am having trouble with what seems pretty simple. I would like to add 2 columns to the right of my pivottable as shown in the uploaded file here:
, one that will be an average of the last 5 days volume, and one that will be the average volume for the past 100 days. I cannot figure out how to properly add the extra fields, any help would be GREATLY appreciated.
Thanks all.
I am having trouble with what seems pretty simple. I would like to add 2 columns to the right of my pivottable as shown in the uploaded file here:
HTML:
http://foxweb.marist.edu/users/kcdhl/pivotquestion.xls
Thanks all.