Pivot Tables, Linked Values
Pivot Tables, Linked Values
(OP)
I have a table of data (see attached example), from which I'd like to extract the maximum load at each attachment location. This is relatively easily done with a pivot table. However, I'd like to list the associated load condition for the maximum load, which I can't seem to figure out. A "robust" solution is required, since I'd like to extend this as part of an existing spreadsheet used by multiple users. Ideas?





RE: Pivot Tables, Linked Values
Never, but never question engineer's judgement
RE: Pivot Tables, Linked Values
See attached.
RE: Pivot Tables, Linked Values
I can make that concept work for my application, thank you!
I'm still interested in whether it is possible to accomplish this from within a pivot table...
COE,
I need/needed to find the maximum load for a given attachment location and direction and the associated load condition. For example, the maximum Py load for attachment 1 is 162.5 lbs at load condition 3.
RE: Pivot Tables, Linked Values
Is this what you had in mind?
RE: Pivot Tables, Linked Values
Basically so it would tell the user "The maximum Py on attachment 1 is 162.5 at condition 3", etc., in a nice tabular format.
The purpose being to prevent errors ocurring when users manually pick out maximum loads for caculations, and also to allow subsequent automated calculations based on the maximum loads.
RE: Pivot Tables, Linked Values
You have a data set with 11 attachments and 5 load conditions. I laid it out by rows of results by attachment, load. So, (1,1) means you got attachment 1 and load 1, etc.
I thought you were trying to arrange the data in an orderly fashion. Is there more and different data for the same conditions? I didn't use a max function for the Py results since you only had 1 set of results for each condition. A sum works fine with what you sent.
Can you unconfuse me? I'd like to help.
RE: Pivot Tables, Linked Values
For a given attachment, lets say attachment 1, I want to find the maximum load for a given direction, lets say Py. This can be done, among other ways, with a max function in the pivot table. Now, that given maximum load came from a certain load condition (only one load condition will have the maximum load for a given mount and direction). I would like to have the pivot table give me the condition associated with the maximum.
jghrist gave a perfectly acceptable way to do it, which I'm working from. Looking at his sheet may help clarify my question. I am still interested in whether it is possible to accomplish this from within the pivot table. This would be useful to me for further processing.