Only Max Value by a Dimension

[m_perreault]

Hi All,

I have a table

Company	% of Sales
Company A	.5
Company B	.25
Company C	.25

My expression for % of Sales is Max(Aggr(Sum(Sales)/Sum(Total Sales),Company))  which I was hoping would return only one row which shows the company with the highest % of Sales such as below.

Company	% of Sales
Company A	.5

Does anyone know how to accomplish what I am looking for?

Thanks,

Mark

[JaMajka1]

Hi Mark,

try to use this expression instead of your dimension:

=if(%_of_sales=aggr(max(total %_of_sales),company),company)

BR,
Maria