This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How can I do a view filter, and pass the formula in the slice

Posted on 08-02-2021 08:16 PM
ADAJALAN
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

3X_7_4_740b9ee65e5b7c204740fc5e52594faa5f488506.png

How can I do a view filter, and pass the formula in the slice. On ux it will only show the latest [Start Date] update of each [NIK]

Solved Solved
0 5 161
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to ADAJALAN
Reply posted on --/--/---- --:-- AM

Try this as your sliceโ€™s Row filter condition expression:

(
  [_THISROW]
  = MAXROW(
    "table",
    "Start Date",
    AND(
      ISNOTBLANK([NIK]),
      ([NIK] = [_THISROW].[NIK])
    )
  )
)

Replace table with the name of the table being sliced.

View solution in original post

Jump to Solution
5 REPLIES 5
Top Labels in this Space