ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to get row2 value into row1 in calculated Field Column in pivo (https://www.excelbanter.com/excel-discussion-misc-queries/226108-how-get-row2-value-into-row1-calculated-field-column-pivo.html)

Arun

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)





All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com