Able to substitute dimension values?

[#1]

I have a simple bar chart with Name as dimension and Revenue as expression.  There are thousands of long names, so the x axis is very cluttered.  I would like to replace the Names with a simple count (1, 2, 3, 4) so that the names are anonymous but identifiable, and the x axis is less crowded.  Is this possible?

[julian_rodriguez]

Hello totinmic

Please see attachment,

[MarcoWedel]

Hi,

I added a numerical reference in the legend to your solution:

maybe it helps

regards

Marco

[#4]

Thank you, very helpful!

When I make a selection on Names, it resets the rank.  For example, if I select the Names ranked 11-20, the x axis resets to 1-10.  How do I adjust the formula to disregard the current selection of Name?

[MarcoWedel · Accepted solution]

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)

and

=Aggr(Rank(Sum({$<NAME=>}REVENUE)), NAME)&': '&NAME