Top ten in straight table with two dimensions

[#1]

Hi,

I have a straight table with the dimensions "ConsigneeCity" and "Consignee", and as expression the waiting time at the consignee. I want my table to only show the ten highes values, but if I select top ten in the "dimension limits" tab, my table keeps going on blank and shows "Allocated memory exceeded". How do I still get the top ten?

[amit_saini]

Hi Niek,

Please try this:

=aggr(if(Rank(sum(Your_Field))<=10,Your_Field),Your_Field) (For calculating Top 10)

Thanks,

AS

[MK_QSL]

Can you share your sample file please?

[#4]

Do as Amit suggests in a calculated dimension then check Suppress When Value Is Null for the dimension in Settings for Selected Dimension.

[joachim_boivie]

You can try this,

sum({<Value={"=rank(total aggr(sum(Value),Dim1,Dim2))<=$(vL.SetTopValue)"}>}Value)

The expression below is something I use for a dynamic top X function in my tables/charts. But its for one dimension only,

(Where the user selects the wanted dimension from the data island - Field) (The dimension is a calculated dim using following, $(=concat(Distinct Field)) )

sum({<$(=concat(Distinct Field))={"=rank(total aggr(sum(Value),$(=concat(Distinct Field))))<=$(vL.SetTopValue)"}>}Value)

[its_anandrjs]

For your dimension field use

Dimension1

Trim(ConsigneeCity)

Dimension2

Trim(Consignee)

Expression

Sum([Waiting time])

and in sort expression

Rank( sum( [Waiting time] ), 10 )

Hope this helps

[arjunkrishnan · Accepted solution]

Hello Frd ,

Use This Expression It Well Useful For U

To View It Top 10 City On 2 Dimensional Wise

if(aggr(Rank(Sum(waitingtime),10),ConsigneeCity)<=10,aggr(Sum(waitingtime),ConsigneeCity,Consignee))