beadedbytes
Technical User
I have a pivot table that has a running total grouped by week (see column below labelled as "Cum of Qty").
Data
DATE BY WEEK Sum of Qty Cum of Qty
7/2/2006 - 7/8/2006 196 196
7/9/2006 - 7/15/2006 198 394
7/16/2006 - 7/22/2006 399 793
7/23/2006 - 7/29/2006 910 1703
7/30/2006 - 8/5/2006 278 1981
8/6/2006 - 8/12/2006 284 2265
8/13/2006 - 8/19/2006 347 2612
8/20/2006 - 8/26/2006 1071 3683
8/27/2006 - 9/2/2006 462 4145
I would like to add another running total column that describes '7/2/2006-7/8/2006' with a value=week1; '7/9/2006-7/15/2006' with a value=week2; '7/16/2006-7/22/2006' with a value=week3, etc.
Is there any way to have this 2nd running total inside the pivot table?
Data
DATE BY WEEK Sum of Qty Cum of Qty
7/2/2006 - 7/8/2006 196 196
7/9/2006 - 7/15/2006 198 394
7/16/2006 - 7/22/2006 399 793
7/23/2006 - 7/29/2006 910 1703
7/30/2006 - 8/5/2006 278 1981
8/6/2006 - 8/12/2006 284 2265
8/13/2006 - 8/19/2006 347 2612
8/20/2006 - 8/26/2006 1071 3683
8/27/2006 - 9/2/2006 462 4145
I would like to add another running total column that describes '7/2/2006-7/8/2006' with a value=week1; '7/9/2006-7/15/2006' with a value=week2; '7/16/2006-7/22/2006' with a value=week3, etc.
Is there any way to have this 2nd running total inside the pivot table?