Ranking position on text box filtering

Anonymous — Wed, 13 Jan 2016 15:12:34 GMT

Hi everyone,

I posted a similar question some time ago. The issue is similar but with a variation.

I need to display in a text box the ranking of the value in a dimension against the others also when the value in that dimension is filtered.

suposing the following table:

LOAD * INLINE [

Dim1, Value

a, 120

b, 30

c, 45

d, 15

];

I get the right ranking positions with the expression

=Aggr(Rank(Sum(Value)/Sum(Total Value)), [Dim1]):

the problem appears when I filter the value on Dim1 (which is mandatory):

"B" should be the third as seen before, but as I filter over it, it's the only value and the rankig says it's the first.

Does any one know how to solve this?

Thanks in advanced.

Re: Ranking position on text box filtering

sunny_talwar — Wed, 13 Jan 2016 17:13:54 GMT

Try this:

=Aggr(Rank(Sum({<Dim1>}Value)/Sum(TOTAL {<Dim1>} Value)), [Dim1])