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.
Go to Solution.
Try a smart filter, this will help you to set search conditions for each user.
Check below link,
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'"
We cannot use the Rank function on User Dimension. Why do you need to use rank for the filter?
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
For the RANK function, I solved it myself.I understand that users cannot use the RANK function.I'm really thankful to you.