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.
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) = 1Regards,Anirudh
Along the same lines as what @anirudh was saying, use this formula:
CUMULATE(1, FALSE, #Entry) = 1
@anirudh missed the False