Show year only when it is max of sales for that year

[#1]

Hi Folks

I have a chart that shows the sales value for the year with the highest sales as follows:

Max ( Aggr ( Sum ( SalesValue ) , CompanyName , SalesYear )

How would I include the year as a dimension in this table? If I simply include the year then of course it's going to show me all years. If I use the following:

IF ( Sum(SalesValue) = Max ( Aggr ( Sum ( SalesValue ) , CompanyName , SalesYear ) , SalesYear )

I get an "Error in Calculation", any suggestions as to what I could do here?

[#2]

One more ')' required?

IF ( Sum(SalesValue) = Max ( Aggr ( Sum ( SalesValue ) , CompanyName , SalesYear ) ), SalesYear )

A similyar expression works for me.

--Arun