Conditional show the column

[sat_tok52]

Hi All,

I have 100 rows in my table and have to show condition column based on filter selections.if no selection of filter i have to show first 20 rows Top and 20 to 60 as middle and rest of the rows bottom. suppose if any user select a filter based on the filter selection the row no will change, suppose if it is 2 row's first row is top and second one is bottom,suppose if it is 3 row , first one is top and second one is middle and third one is bottom , like wise i have to show the conditional column.  

Any help.

Thanks.

[Yoshidaqlik]

Hi

For this case you have a variable with the 3 options to choose right?

if the number is fixed as mentioned you can use the function in the dimension

=
IF( var_1='TOP',
	aggr(
    	if(
    		Rank(sum(Value),4) <= 20,
            Dim_1
        )
    ,Dim_1),
IF( var_1='MIDDLE',
	aggr(
    	if(
    		Rank(sum(Value),4) > 20 and Rank(sum(Value),4) <= 60,
            Dim_1
        )
    ,Dim_1),
IF( var_1='BOTTON',
	aggr(
    	if(
    		Rank(sum(Value),4) > 60,
            Dim_1
        )
    ,Dim_1)
    
)))

Regards