Hello friends,

I have a pivot table that looks like this.

Header row
---
Parameter Condition1 Condition2 .... conditionN Min Max
---


For each parameter there are multiple of conditions1 thru N possible. For each unique combination of paramater, and condition 1 thru N, there is a specific data value. I am calculating the Min and Max across all conditions for each parameter.
Is there a way, I can get the Pivot table to display the exact unique combination of conditions that caused the Min and the combination that caused the Max. Or is there a way, I can extract that information from the table.

So the display might look like this.

parameter1 x1 y3 z3 .. Min value
parameter1 x3 y2 z3 .. Max value

Thanks in advance
Kumar