Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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