Pivot table field calculations

T

tallmendinger

I am trying to create a field in a pivot table that performs an
operation - multiplying one field times another. I do not get logical
results

set up is something like this
Company 1, % Ownership of company x, Company X revenues Product A

Company 1, % Ownership of company y, Company y revenues Product a

and so on for Company 2, Company 3 etc
Each company has % in multiple other companyies and products

I am trying to calculate the total revenues from product a that accrue
to Company 1 on a % ownership basis. I create the new field, insert the
exisiting field in the forumula ..

The results are right for the the first item - % Ownership * Company X
revenues product A BUT completely off for next Item

any suggestions ?
Thanks
 
Top