isfirtstoccurrence formula

[DMManalili]

Hi, question please. I need to get the first data(#1), hence I used the isfirstoccurrence but not sure on why the #2,#133 and #362 are also checked in the boolean? Thank you. 

[anirudh · Accepted solution]

Isfirstoccurrence should be used to get the first line of unique data and not the first line itself. To get the first data do this instead:
CUMULATE(1, #Entry) = 1

Regards,
Anirudh

[rob_marshall · Accepted solution]

Along the same lines as what @anirudh was saying, use this formula:

CUMULATE(1, FALSE, #Entry) = 1

@anirudh missed the False

[DMManalili]

thank you 🙂