Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi there,
ı want to display top 3 values in a text objext of a dimension.
how can ı do this?
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)
Try with in text box :
='First :'&FirstSortedValue(Dimension, - Expression, 1) &Chr(10)&'Second:'&FirstSortedValue(Dimension, - Expression, 2) &Chr(10)&'Third:'&FirstSortedValue(Dimension, - Expression, 3)
May be like this
=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Money(Aggr(Sum(Value),Dimension)),Chr(10))
When you need text object?
=Concat({<[Ticket ID]={"=Rank(Sum(Sales), 4) <= 3"}>} Aggr(Sum(Sales),[Ticket ID]),Chr(10))
=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Distinct Dimension,Chr(10))
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.
Please share some sample file with expected output.
concat({<term = {"=rank(sum(Sales)) <=3"}>} Distinct term, chr(10))