Mick, I feel sure that what you are looking for is do-able but I don't have
the time right now to look into it further.

If you could spell it out in PivotTable column names (exactly what you have
got there at the moment) and a few rows of example data within those columns
I feel sure that somebody will be able to provide a solution.

"Mick Henn" wrote:

Thanks for the help! This is very helpful but i think i am trying to use
functionality which is not there.

The value which i need to report on is the Total minus The amount of items
which had no issue on the second pass of QA checks (i.e. if the number is
zero a second check is no longer needed). I understand how this is more
complex than the example you have provided because i am trying to calculate
based on specific values within a feild rather than the field header as shown
in your example.

p.s. yes i am using Excel 2007

"trip_to_tokyo" wrote:

EXCEL 2007

Mick, you seem to want a Calculated Field.

1. There are a couple of examples at:-

http://www.pierrefondes.com/

2. Items 71 and 70. These 2 items should be read in conjunction with one
another.

3. Item number 68.

If my comments have helped please hit Yes.

Thanks.




"Mick Henn" wrote:

Is there any way that i can add an extra column to a pivot table that I can
add a function into?

We have 2 internal quality checks for our product. I have created a log
which shows what type of issues are discovered in the first and second
quality check.
The pivot table in its most basic form shows the count of the different type
of issues found in the first QA check in the rows and the type of issues
found in the second QA check in the columns.

The nature of this layout means that looking at the Grand Total is
meaningless from a process analysis point of view. What I would need is to
add an extra column to the table which calculates the difference between the
items which were not the same on the first and second QA check (i.e. they
passed the first time, but failed the second time or vice versa).

Any help with this would be greatly appreciated as I am currently using the
cells outside of the table to make these calculations and that poses problems.