Min/max

[#1]

Hi,

i have a pivot table with 1 dimensions: firm.

I need to retrieve the min value of costs: i create a text object with the formula -->

=

num((min(aggr(sum(Cost), Firm))), '#.##0,##', ',' , '.')

How can i display the name of the firm connected with the min value in the same formula ?

Thank you

Paolo

[#2]

= Firm & num((min(aggr(sum(Cost), Firm))), '#.##0,##', ',' , '.')

Is this what you're after?

Jamie

[#3]

I have tried but don't work. The name of the firm dont' appear.

[#4]

Instead of a Text Object, you could use a Straight Table chart to calculate and display this information.

Set the expression to no totals, on Presentation Properties, set Max Number to 1, sort by the expression column Ascending, disallow Interactive Sort, remove the Caption, etc.

Phil Bishop