• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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
0
vizionforce
Asked:
vizionforce
  • 2
  • 2
1 Solution
 
Rory ArchibaldCommented:
Simplest way I think would be to Sum the field in the table and then create another table alongside using GETPIVOTDATA formulas. See attached.
ResourceProblem.xlsx
0
 
vizionforceAuthor Commented:
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...
0
 
Rory ArchibaldCommented:
I don't think there is a good solution without code.
0
 
vizionforceAuthor Commented:
I think you're right.  Might be why I've always steered away from PTs!  Thanks for your input!
0
 
TracyVBA DeveloperCommented:
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.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now