Link to home
Start Free TrialLog in
Avatar of vizionforce
vizionforce

asked on

Excel Pivot Table - Manipulate the Average

I'm trying to get a Pivot Table to display values based on summed values divided by a variable available elsewhere or within the pivot table. Detailed problem description in Notes tab of attached workbook. ResourceProblem.xlsx
Capture.JPG
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vizionforce
vizionforce

ASKER

Thanks, that's headed the right direction.  But I'd like to be able to drag multiple Row Lables into the Pivot Table, but when I do the formulas (understandably) break...  I suppose I could write a macro to rebuild the formulas...
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image
I don't think there is a good solution without code.
Avatar of vizionforce
vizionforce

ASKER

I think you're right.  Might be why I've always steered away from PTs!  Thanks for your input!
Avatar of Tracy
Tracy
Flag of United States of America image
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.