remove duplicate rows based on one column in Web Intelligence report

[Former Member]

hello,

i need to edit a Web Intelligence report design to remove duplicate rows based on a column and retrieve only the latest value.

check above photo for more description.

[amitrathi239]

create variable Show/Hide=if([Submission date]=max([Submission date]) in (ID)) then "Show" else Hide"

Apply filter on Show/Hide variable where equal to Show.