rank in text object

[Anonymous]

hi there,

ı want to display top 3 values in a text objext of a dimension.

how can ı do this?

[prma7799]

Try this

aggr(if( rank(sum(Sale),4)<=3,State), State)

or

aggr(if( rank(sum(Sale))<=3,State), State)

aggr(if( rank((YourExpression))<=3,Dimension), Dimension)

[sergio0592]

Try with in text box :

='First :'&FirstSortedValue(Dimension, - Expression, 1) &Chr(10)&'Second:'&FirstSortedValue(Dimension, - Expression, 2) &Chr(10)&'Third:'&FirstSortedValue(Dimension, - Expression, 3)

[antoniotiman]

May be like this

=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Money(Aggr(Sum(Value),Dimension)),Chr(10))

[Anil_Babu_Samineni]

When you need text object?

=Concat({<[Ticket ID]={"=Rank(Sum(Sales), 4) <= 3"}>}  Aggr(Sum(Sales),[Ticket ID]),Chr(10))

[antoniotiman]

=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Distinct Dimension,Chr(10))

[Anonymous]

thanks for reply,

I have "term" dimension, and I wrote it like that;

=aggr(if( rank ( (sum(sales)-above(sum(sales),-1))/above(sum(sales),-1)) = 1,term), term)

it displays result but the wrong result. does not give the right rank=1 term

when I use the same formula

rank ( (sum(sales)-above(sum(sales),-1))/above(sum(sales),-1)) = 1

in a table, it gives different result.

[prma7799]

Please share some sample file with expected output.

[shraddha_g]

concat({<term = {"=rank(sum(Sales)) <=3"}>} Distinct term, chr(10))