Patrick,

Thanks for the idea for making the calculations by arranging the pivot
table as follows:

page field: company
column field: year
row field: division
data field: value

The only thing is the calculations for "profit" for all of the companies
have to appear on the same page for cross comparison purposes.

I wonder if it might be possible to create an extra column in the
dataset and to somehow do the calculation and put the calculations
there. Then go ahead and create the pivot table with the calculation for
"profit" already as one of the columns for selections.

Is there some way the calculation could be done using the vlookup
function, maybe along the lines of?:

if "company" field = pepsi:
look through whole data set for all lines with country X and year X.
When all these lines found, use these lines to make calculation for
"profits" as sum of all values where "division" = "marketing", "human
resources"

whereas
if "company" field = nike:
look through whole data set for all lines with country X and year X.
When all these lines found, use these lines to make calculation for
"profits" as sum of all vlaues where "division"= "sports",
"advertising","marketing"

etc. for each of the companies.

* Had forgotten to mention that "profits" are also calculated by country
and year for each of the companies.

Thank you and best regards.

Adam


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!