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!

[justinphamvn]

Hi antoniodneto,

You can edit table and  drop down dimension then choose a limitation of values (from top or bottom).

The Top or Bottom value will be calculate on the first measure of table

Hope this helps,

Justin.

[antoniodneto]

Hi Justin,

Actually I'm doing that for each dimension calculated on my measure RISCO, but is not working, still showing more than TOP 20.

Tks

[swuehl]

Maybe add a set expression filter to your RISCO measure expression aggregation function (Assuming a simple Sum(RiskVal), but it doesn't matter for the set expression:

=Sum({<GRUPO= {"=Rank(Sum(RiskVal))<=20"}>} RiskVal)

[timpoismans]

It actually is working. It's showing a top 20 for the dimensions, based on RISCO.

But it's not showing a top 20 for a combination of all dimensions per row.

[antoniodneto]

Hi Tim,

It's exactly I need the TOP 20 off all dimensions combined base on RISCO.

How Can I solve that?

[timpoismans]

Not entirely sure, never really had this kind of problem, but perhaps something like the following:

Add a new dimension to the script like:

GRUPO&SETOR&STATUS&RATING          as SortDim

And then try using the following expression:

Sum({<SortDim= {"=Rank(Sum(RiskVal))<=20"}>} RiskVal)

[antoniodneto]

Hi Tim,

I created the new dimension, but did not work.

When I use <=20 for RISCO it returns the TOP 19

When I use another measure for exemple to show TOP 10 returns only 7

I don't know what to do.

Tks

[antoniodneto]

Hi Tim,

I created the new dimension, but did not work.

When I use <=20 for RISCO it returns the TOP 19

When I use another measure for exemple to show TOP 10 returns only 7

I don't know what to do.

Tks

[antoniodneto]

Hi Stefan,

Can you help me please?