View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arun Arun is offline
external usenet poster
 
Posts: 103
Default 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)