Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PivotTable:Using a calculated field result in another calculated f
I have a calculated field in the Data section. This field is a running total
across the row. The fieldname is YTDOrders. For each month across the Data row,the running total is fine. I want to use this Calculated field in another calculated field. Such as: NewYTDOrders, where the calculation would be YTDOrders + 2. Layout: Month1 Month2 Month3 Doors Orders 3 6 9 YTDOrders 3 9 18 NewYTDOrders 5 11 20 (this is what I need) NewYTDOrders 5 8 11 (this is what I get) It always refers to the Orders line, even tho the Calc is = YTDOrders + 2 ANy ideas to try would be vastly appreciated! -- Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
how to create a calculated field from another calculated field? | Excel Discussion (Misc queries) | |||
Calculated fields in pivot tables | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |