C
Corbin
Hi,
I am trying to create a pivot table/chart from data that is listed b
week. So my table has "week" as the row field and "total X" as th
column field. I want the chart to display the total for each week as
bar (the easy part) and also to graph the average of the last fou
weeks as a line on top of the bar graph. I have tried to figure ou
how to add a calculated pivot item but I can't seem to get it to wor
right. So for each week there would be a second almost subtotal lik
entry that calculates the average for the previous four weeks (if ther
aren't four previous weeks it can just take the average of however man
weeks there are). This is kind of what I envision but if anyone has
different approach I'm open.
Sum of X
Week...................................Total X
1.............................................5
Subtotal (4wkavg)......................5 <----------avg of wee
1
2.............................................4
Subtotal (4wkavg)......................4.5 <---------avg of week
& 2
3.............................................3
Subtotal (4wkavg)......................4 <--------avg of wee
1,2,&3
4.............................................7
subtotal (4wkavg)......................4.75 <-------avg of wee
1,2,3,4
5.............................................8
subtotal (4wkavg)......................5.5 <------avg of wee
2,3,4,5
6.............................................3
subtotal (4wkavg)......................5.25 <------avg of wee
3,4,5,6
I am trying to create a pivot table/chart from data that is listed b
week. So my table has "week" as the row field and "total X" as th
column field. I want the chart to display the total for each week as
bar (the easy part) and also to graph the average of the last fou
weeks as a line on top of the bar graph. I have tried to figure ou
how to add a calculated pivot item but I can't seem to get it to wor
right. So for each week there would be a second almost subtotal lik
entry that calculates the average for the previous four weeks (if ther
aren't four previous weeks it can just take the average of however man
weeks there are). This is kind of what I envision but if anyone has
different approach I'm open.
Sum of X
Week...................................Total X
1.............................................5
Subtotal (4wkavg)......................5 <----------avg of wee
1
2.............................................4
Subtotal (4wkavg)......................4.5 <---------avg of week
& 2
3.............................................3
Subtotal (4wkavg)......................4 <--------avg of wee
1,2,&3
4.............................................7
subtotal (4wkavg)......................4.75 <-------avg of wee
1,2,3,4
5.............................................8
subtotal (4wkavg)......................5.5 <------avg of wee
2,3,4,5
6.............................................3
subtotal (4wkavg)......................5.25 <------avg of wee
3,4,5,6