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

Accepted answers

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

All comments

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

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…