Forum Discussion
summer18
5 years agoHelper III
exclude duplicate displayed in matrix table
Hi, When I created a matrix table in my dashboard, I want to exclude specific rows where there are duplicate invoice line number and null PO Number. In the column "exclude", it displays the tag whi...
amitchandak
5 years agoSuper User
summer18 , Looking at sample data you can take PO Number as value in Matrix as Min or Max. Or in the table as Min/max or first/last in table
or use formula for PO firstnonblank(Table[Po],blank())