I am grouping files by "owner", and in cases where 2 files with the same owner also share the same "category", i would like to filter out all but the most recent "date".
Along with a workbook. I have included a screenshot with example data, with a row crossed out that should be filtered.
Any help would be greatly appreciated.
2 answers
@calder p
Hi, in this case you can use:
Filter
{FIXED [Owner],[Category]:IF COUNT([File])>=2 THEN MIN([Date]) END}=[Date]
And exclude the true value.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
Tableau Ambassador
