convert result from value to dimension

[#1]

Hi I have text box which shows max value of price/cost according to product dimension. I want to show product name in text box.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

I already answered in your previous post, but here we go

=Only({1} 
If(
Aggr(
Rank( 
Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} UnitPrice) / Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} TotalProductCost), 4, 1)
, Product) = 1
, Product)
) 

Kind of cumbersome because of the selection, that you want to ignore, hence all those {1}.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica