View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lackawanna52 Lackawanna52 is offline
external usenet poster
 
Posts: 6
Default Pivot Table, Calculated Field

I have a RowField ("Cycle") with two items ("Annual Plan", "Current
Forecast") and a ColumnField with four items (Q1, Q2, Q3 and Q4). I want to
add a third RowField item called "Variance" and have it be the difference
between the Annual Plan and the Current Forecat for each ColumnField.
1. How do i add the new RowField item via VB?
2. How do i add the calculation formula via VB?

Thanks for all your help...!