smartin:

Thank you for the follow-up. I tried the method as suggested by you. It only
added another for each month; the added rows are identical to the rows that
already are in the Count Field. Any other suggestions? I am using Excel 2003.
Does this make a difference?

Also, in my original raw data table I have created additional columns to
compute the cumulative and % using the following formulae. I was successful
for only one Item. Any suggestions to include the second Item in the formulae?

=COUNTIF($C$2,"Item1")
=SUMPRODUCT(($C$2="Item1")*($D$2:D2="Pass"))

Hope this is making sense. Thanks in advance.


"smartin" wrote:

learnlearn52 wrote:
smartin:

Thanks for your response. I have considered the PT option for the following
reasons. I am tracking data for two types of products as they are being built
on a weekly basis and they are entered into the raw data. With the PT, I can
review the data with the pull-down option for each item in the Page Fields
area of the PT. By doing so I can prepare only one dynamic chart and pick
which Item for which I want the information to be displayed (both the monthly
data as well as the chart).

If the data can be manipulated (calculated) in the raw data table then the
info can be displayed in the PT also and the dynamic charts can be created
with ease.

I have displayed (limited amount as an example) a typical table which shows
the tracking of the data for the two Items.


Feb-08 Item 1 Fail
[snipped]
Jun-08 Item 2 Fail

Based on these data, can I create two more columns showing the cumulative
totals as well as the cumulative grand totals for each Item. If yes, what
formulas may be used. One can then use these numbers to calculate the % and
they can be made part of the PT. The dynamic charts based on the PT are then
a breeze. I hope this is making sense.

Thanks once again.

To create cumulative as well as incremental totals with a PT, add the
value field (for you I think that's count of something) to the data area
a second time. Excel will add it as interlaced rows among the row
categories -- we'll fix that in a minute. Now change the field settings
for this new item: right click it, Options, Show Data As and select
"Running Total in". The base field you want is probably whatever the row
category is.

Now to rearrange this so the data are all in one row instead of
interlaced rows, drag the data handle and drop it as if you wanted to
move it to the column area. (Thanks to Mike Alexander for that last trick.)

Hope this helps!