View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arun Arun is offline
external usenet poster
 
Posts: 103
Default How to Show SUM of field value in other column

Hi all,

I have a pivot table, in that my data is arranged in given manner:

% RPW
..01%
..02%
SUM:.03%

I want one more column which show this SUM, in each row:
% RPW Total
..01% .03%
..02% .03%

Note: Fields are in pivot table, so we can not take any cell refernces, here
we can use only calculate items for formula but iam not able to find
workaround for this.