Rank with many Dimensions

[antoniodneto]

Hi Guys,

I have this table below:

I want to rank the top 20 at RISCO, now my table is showing all the numbers. I'm trying to use the Rank function, but no results.

Can you help me?

Tks!

[kenphamvn]

Hi

Please try this

Aggr(If(Rank(sum([T683165_RESUMO_NOVO_DASH.RISCO])/1000000)<21,sum([T683165_RESUMO_NOVO_DASH.RISCO])/1000000)
, [T683165_RESUMO_NOVO_DASH.GRUPO_TFC_ATUAL]
, SETOR
,[T683165_RESUMO_NOVO_DASH.SIT_CLI]
,[T683165_RESUMO_NOVO_DASH.FAIXA_VA]
)

Regards

An Pham

[timpoismans]

Could you provide us with some sample data?

Would be easier to determine exactly what the problem is and how we can solve it.

[antoniodneto]

Hi Tim,

I attached the app below. In Stefan's reply.

It helps you?

[timpoismans]

It's easier to work with the data as we can reload a "test app" on our side. Or could you possibly attach a new version of the app with the SortDim I suggested and two tables in which the Top 10/20/30/... isn't functioning as it should.

[antoniodneto]

Hi An

Look that

The table left is with your expression it works to show 20 but look the table right (full data) I'm loosing some guys.

Tks

[antoniodneto]

Hi Tim,

Follow a new APP attached with 2 tables, one with TOP20 and one with another measure to rank TOP 10.

Tks a lot!

[timpoismans · Accepted solution]

Hi Antonio

Please look at the included app. You should include Null-values from your dimension. The rank function does so as well.

If you don't include them, the measure is still correct, but as you've said, you are missing values from the table. !

[antoniodneto]

Hi Tim!!!

Tks for your help, now I got what I needed!!

Take care!!