Hello All. Thank you for taking time to help me solve my problem.

I need to get the cumulative count of planned date and actual date for each
month by UID and Task Type.

I am wondering if there is a way to use pivot table to get cumulative count?
Thanks much.

The result set I want is:
UID Date QA Planned QA Actual STK Planned STK Actual

1 Oct-2005 2 2 1
1
1 Nov-2005 3 3 4
2

The raw data looks like below:


Task Type UID Planned Date Actual Date
QA 1 10/5/2005 10/5/2005
STK 3 10/12/2005 10/12/2005
QA 1 10/19/2005 10/19/2005
STK 2 10/26/2005 10/26/2005
QA 1 11/2/2005
STK 1 11/9/2005
QA 2 11/16/2005 11/16/2005
PR 2 11/23/2005 11/23/2005
STK 1 11/30/2005
PR 3 12/7/2005
QA 1 12/14/2005 12/14/2005
STK 2 12/21/2005 12/21/2005
QA 3 12/28/2005 12/28/2005
QA 4 1/4/2006

A pivot table should works just great for this... Create the pivot table by
placing the UID in the left column and the Planned date right next to it.
Place the Task type across the top row. Now place the Planned date and the
actual date in the middle (this should generate a count of the dates). Right
click on the planned date in the left hand column and select "Group and Show
Detail". You should be able to group this by month and year. Now just drag
the Data drop down from the left column to the top row... This should give
you the results you are looking for...
--
HTH...

Jim Thomlinson


"luvgreen" wrote:

> Hello All. Thank you for taking time to help me solve my problem.
>
> I need to get the cumulative count of planned date and actual date for each
> month by UID and Task Type.
>
> I am wondering if there is a way to use pivot table to get cumulative count?
> Thanks much.
>
> The result set I want is:
> UID Date QA Planned QA Actual STK Planned STK Actual
>
> 1 Oct-2005 2 2 1
> 1
> 1 Nov-2005 3 3 4
> 2
>
> The raw data looks like below:
>
>
> Task Type UID Planned Date Actual Date
> QA 1 10/5/2005 10/5/2005
> STK 3 10/12/2005 10/12/2005
> QA 1 10/19/2005 10/19/2005
> STK 2 10/26/2005 10/26/2005
> QA 1 11/2/2005
> STK 1 11/9/2005
> QA 2 11/16/2005 11/16/2005
> PR 2 11/23/2005 11/23/2005
> STK 1 11/30/2005
> PR 3 12/7/2005
> QA 1 12/14/2005 12/14/2005
> STK 2 12/21/2005 12/21/2005
> QA 3 12/28/2005 12/28/2005
> QA 4 1/4/2006
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>