ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding calculated fields (https://www.excelbanter.com/excel-programming/283032-adding-calculated-fields.html)

pilmart[_3_]

Adding calculated fields
 
I have 2 calculated fields in a pivot table, one is a sum
field (Field1) the other a count field (Field2). Can i add
another calculated field based on the values contained in
Field1 & field2. Everything seems to indicate that his is
not possible. Has anyone any ideas on how to do this ???

GJones

Adding calculated fields
 
Could you get outside the pivot table and just write a
regular formula that references Field1 and Field2. It
should work as long as the two fields are always located
in the same location.

Thanks,

Greg
-----Original Message-----
I have 2 calculated fields in a pivot table, one is a sum
field (Field1) the other a count field (Field2). Can i

add
another calculated field based on the values contained in
Field1 & field2. Everything seems to indicate that his is
not possible. Has anyone any ideas on how to do this ???
.



All times are GMT +1. The time now is 05:34 PM.

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