Rank function in a block chart

[ericheleine]

hi everyone,

I have an issue with the function Rank

My goal is to have the same block chart  below but only with the 5 first name sort by value

I selected 2 dimensions: Name & Factor

the formula is :

=aggr(sum([Value]), NAME,FACTOR)

When I use Rank I loose all my datas

Someone have an idea to resolve the pb?

[Anonymous]

Eric,

First, there is no such thing a s"sort" in the block chart.
Second, you probably do not need rank() function.  You can use "dimension" limit - show only largest five values.

Regards,
Michael

[ericheleine]

thank you michael your answer has been heplfull