Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get row2 value into row1 in calculated Field Column in pivo
In "Calculate Item Field", how can i show the row2 value in row 1.
But here we can not use cell refernces because it isa calculated field column in pivot table. %xyz how can i show that column like this: %xyz %xyz 10 --- 10+20+30(adding row2, row 3, with row1) 20 -- 10+20+30(adding row2, row 3, with row1) 30 -- 10+20+30(adding row2, row 3, with row1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
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) |