| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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...! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
| Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Formulas Calculated Item / Calculated Field | Excel Programming | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Threaded Mode
