Wrox Programmer Forums Pivot Tables
 | Search | Today's Posts | Mark Forums Read
 Excel VBA Discuss using VBA for Excel programming.
 Welcome to the p2p.wrox.com Forums. You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
May 12th, 2004, 10:08 AM
 Authorized User Join Date: Oct 2003 Location: , , USA. Posts: 15 Thanks: 0 Thanked 0 Times in 0 Posts
Pivot Tables

I am trying to create a pivot table where I have values created with formulas. The numbers would be created from the count. The formulas need to be on each type of Item and the associated defect. I am trying to create something like this inside a pivot table.

Defect Codes CMP DC FF LVS PDC Total
Six Month Pareto 3 2 1 0 1 7
Cumulative 3 5 6 6 7
Percent of Total Defects42.9% 71.4% 85.7% 85.7% 100.0%

These forumlas refer to the cumulative running total. The first formula is for the first defect and the second forumla is for the rest of the defects across the pivot table.
FormulaR1C1 = "=R[-1]C"
Range("C15").Select
ActiveCell.FormulaR1C1 = "=R[-1]C[-1]+R[-1]C"
Range("C15").Select

This Formula is related to the Total divided by the total for the Items at the end of the row in the pivot.
ActiveCell.FormulaR1C1 = "=R[-1]C/R[-2]C[15]"
Range("B21").Select

Betsy

 Similar Threads Thread Thread Starter Forum Replies Last Post VBA for Pivot Tables stealthdevil Excel VBA 3 March 21st, 2007 04:01 PM how to work pivot tables malli_kv2 Access 1 March 16th, 2007 06:34 AM Formula in Pivot tables JPC Excel VBA 1 February 20th, 2007 01:27 PM Linking pivot tables iacon Excel VBA 3 July 24th, 2006 01:25 AM International Pivot Tables noldrini Excel VBA 0 February 8th, 2006 12:54 PM