G
Guest
I am working on a pivot table and trying to recreate something I did last
month. I am having two basic problems. Any help is appreciated!
I want to group by month to list the average and the maximum. The data is
llike the following:
Date Val
12/29/2006 1
12/30/2006 2
12/31/2006 3
1/1/2006 5
1/2/2006 7
1/3/2006 9
What I want the pivot table to calculate is the following:
Data
Month-Year Max of Val Average of Val
Dec 2005 3 2
Jan 2006 9 7
Does anyone have any ideas? I was able to do the following last month, but I
do not know how I got (1) the year as a field and (2) grouping by month.
Data
Year Month Max of Val Average of Val
2005 Dec 3 2
2006 2006 9 7
Thanks!
month. I am having two basic problems. Any help is appreciated!
I want to group by month to list the average and the maximum. The data is
llike the following:
Date Val
12/29/2006 1
12/30/2006 2
12/31/2006 3
1/1/2006 5
1/2/2006 7
1/3/2006 9
What I want the pivot table to calculate is the following:
Data
Month-Year Max of Val Average of Val
Dec 2005 3 2
Jan 2006 9 7
Does anyone have any ideas? I was able to do the following last month, but I
do not know how I got (1) the year as a field and (2) grouping by month.
Data
Year Month Max of Val Average of Val
2005 Dec 3 2
2006 2006 9 7
Thanks!