Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations in a pivot table data set
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculations | Setting up and Configuration of Excel | |||
Pivot Table Calculations | Excel Discussion (Misc queries) | |||
Calculations in a pivot table data set | Excel Programming | |||
Calculations in a pivot table data set | Excel Programming | |||
calculations in large data set and in pivot table | Excel Programming |