LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Pivot Table Totals

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table totals sharder Excel Discussion (Misc queries) 3 June 27th 08 01:52 PM
Pivot table totals? Neil Excel Discussion (Misc queries) 1 November 17th 07 01:08 AM
Totals in Pivot Table Rob Excel Discussion (Misc queries) 5 December 12th 06 11:53 AM
Pivot Table Row Totals Les Excel Discussion (Misc queries) 0 December 7th 06 08:17 AM
Pivot Table Chart - With Pivot Table Totals WCM Charts and Charting in Excel 0 November 29th 06 03:21 PM


All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"