If each type of Note is unique for an entry, then encapsulating your calculated field using MAX() would do the trick.
MAX (CASE WHEN .... ELSE .... END)
Thank you for this feedback,
MAX() do not work with text field, I get an error when I tried your solution,
I believe there is a known error with the current version of smart reporting when trying to use Max() on anything other than a number.
Please check with BMC on the same, as the version that we are using supports such use case with text fields too.