query on pivot table

[#1]

I've a pivot table in which i am populating the min value for one column, but I've another dimension for the same min value which also i want to get populated. CAn someone please help me in doing that.

DimensionA DimensionB

min (Dimension A)= 1 value corresponding to the min (Dimension A) = X

1 X

2 Y

3 Z

4 W

5 M

Now i want to find out a way to show the value corresponding to the min (Dimension A) which is X. couldn't get any way to do that.

can someone please help?

thanks in advance

[rwunderlich]

If I understand the question correctly.

For the first dimension, use a calculated dimension of

=min(DimensionA)

For the seconds dimension, use a named dimension of

DimensionB

-Rob

[#3]

Hi Rob,

Thanks for your reply. but if you can please take a look at the screen shot below, the min(Dimension A) is coming as 77 but there is no values corresponding to 77 in column B. How can we get this resolved?

Thanks .