Show value of a dimension in pivot table

[#1]

Hi,

I have a pivot table with

     - two dimension country (Y axis) and market (X axis)

     - one expression (revenue).

I whant to add the name off the company with the higher revenue for each country/market inside this table.

It will be awesome if I can writ an expression which do this.

Could you give me some help?

Nicolas Carlier

[sunny_talwar]

Where do you imagine to see this information on the pivot table? a second column?

[#3]

Yes on a second column

something like this

[sunny_talwar · Accepted solution]

May be like this:

FirstSortedValue(Company, -Aggr(Sum(Revenue), Country, Market, Company))

[sunny_talwar]

Or you can try this:

Concat(Aggr(If(Sum(Revenue) = Max(TOTAL <Country, Market> Aggr(Sum(Revenue), Country, Market, Company)), Company), Country, Market, Company), ', ')

[#6]

That works perfectly well!

Thanks a lot !