How to Set search conditions for each user

taku.s
taku.s
in Modeling

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

Tagged:

Best Answer

Answers

  • taku.s
    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
    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
    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
    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

Categories