Top N chart Help

[Anonymous]

Hi All,

I need to create a dynamic Top N performance chart. I am having Owner as a Dim and Count(Service) as Exp.

So my exp like below

if(aggr(rank(Count(Service)),Owner) <=v_Rank, Owner, null())

The Variable needs to get input from end user.Here I what I am missing

[arulsettu]

HI

try this

=if(aggr(rank(Count(Service),3),Owner) <=v_Rank, Owner, null())

[Anonymous]

Hi Arul,

It is not working. Also here what 3 Ref?

[arulsettu]

hi

3 will return highest rank of all rows

can you  post sample data source

[ecolomer]

Try this:

=if(aggr(rank(Count(Service),3),Owner) <=$(v_Rank), Owner, null())

[Anonymous]

Hi Enrique,

    Still it is not working. $ didn't helped me.

-Jay

[arulsettu]

hey in rank function

Suppression of zero values is automatically disabled when these functions are used. NULL values are disregarded.

so why you using null()

[ecolomer]

For me is good, see this example

[Anonymous]

Hi Arul,

Due to data sensitivity, I cant share.Like I shown earlier post, it is simple data.

[alkesh_sharma]

If you are not using a pivot chart, you can simply you can simply limit dimensions suing dimension limit tab.