How to Set search conditions for each user

taku.s

Hi everyone.

 

I would like to set search conditions for each user and I want to filter and display data.

There are 110,000 items of data I want to display, and I want to specify search conditions for each user and filter and display them.

Please tell me a good solution. 

 

Best regards.

 

Taku

VIGNESH.M

Hi Taku,

 

Try a smart filter, this will help you to set search conditions for each user.

 

Check below link,

https://community.anaplan.com/t5/Best-Practices/Increase-End-User-Adoption-With-Smart-Filters/ta-p/42821 

 

Regards,

Vignesh M

taku.s

Hi,@VIGNESH.M 

 

Thank you very much. I will refer to here.

By the way, if Users List is set to Dimension, RANK function cannot be used?
The following error was displayed:
"Invalid use of 'Users' list with function 'RANK'"

 

Best regards,

Taku.

VIGNESH.M

Hi,

 

We cannot use the Rank function on User Dimension. Why do you need to use rank for the filter?

 

~Vignesh M

taku.s

Hi,

 

Thank you for your reply.

I am using the RANK function because I want to get 10 rows from the last record entered.

 

For your reference, the formula is below

 

IF RANK(1, ASCENDING, SEQUENTIAL, Entered FLG) <= 10 THEN List.NO ELSE 0

 

 

Regards.

Taku

taku.s

Hi　@VIGNESH.M 

 

For the RANK function, I solved it myself.
I understand that users cannot use the RANK function.
I'm really thankful to you.

 

Best regards.

 

Taku