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"
ActiveCell.FormulaR1C1 = "=R[-1]C[-1]+R[-1]C"
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"