Conditional Display text

[sat_tok52]

Hi All,

I have to show conditional dimension Top 20 and Mid 60 and bottom 20  .if the user selected a filter   based on that selection the records count i have to display Top and mid and bottom  .  Any help.

-Sateesh

[Yoshidaqlik]

Hi

in that case you should put the expression in the dimension

I'm guessing that your filter will be a variable

if(var_1 = 'Top20',
	aggr(
    	if(
        	Rank(Sum(value),4)<= 20,
            dimension_xxxxxx
        )
    ,dimension_xxxxxx),
if(var_1 = 'Top21 at 60',
	aggr(
    	if(
        	Rank(Sum(value),4)> 20 and Rank(Sum(value),4)<= 60,
            dimension_xxxxxx
        )
    ,dimension_xxxxxx),
    aggr(
    	if(
        	Rank(Sum(value),4)> 60,
            dimension_xxxxxx
        )
    ,dimension_xxxxxx)
))

Regards

[sat_tok52]

Hi Yoshidaqlik,

Thanks for your quick replay. I am not using variables as filter.

Thanks

[Yoshidaqlik]

So would it be as if they were graphs of different tables is this?

Top 20:

aggr(
    	if(
        	Rank(Sum(value),4)<= 20,
            dimension_xxxxxx
        )
,dimension_xxxxxx)

Mid 21 - 60:

aggr(
    	if(
        	Rank(Sum(value),4)> 20 And Rank(Sum(value),4)<= 60,
            dimension_xxxxxx
        )
,dimension_xxxxxx)

Botton 20:

aggr(
    	if(
        	Rank(-Sum(value),4)<= 20,
            dimension_xxxxxx
        )
,dimension_xxxxxx)

regards