Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I have the following expression
=Aggr( if(Rank(Sum({<Año = {'2012'},Semana_GL = {'$(=$(vMaxSemana)-1)'}, AgpPautaNombre=>}SoutMontoDespTotal)) = 3, AgpPautaNombre), AgpPautaNombre)
The idea is that for a specific week in the year, I want to know which AgPautaNombre was in the 3rd place.
This works ok when I dont have a selection of AgPautaNombre.
The thing is that what I really want to do is when I select an AgPautaNombre, I want to know which AgPautaNombre was in the selected AgPautaNombre rank last week, but when I make the selection my textbox goes null.
I'm kind of blocked, any Ideas?
Any ideas?