![]() |
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 ??? |
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