How to Set search conditions for each user

Highlighted
Contributor

How to Set search conditions for each user

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

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: How to Set search conditions for each user

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/4... 

 

Regards,

Vignesh M

Highlighted
Contributor

Re: How to Set search conditions for each user

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.

Highlighted
Master Anaplanner/Community Boss

Re: How to Set search conditions for each user

Hi,

 

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

 

~Vignesh M

Highlighted
Contributor

Re: How to Set search conditions for each user

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

Highlighted
Contributor

Re: How to Set search conditions for each user

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