Hi al, I have a tableau worksheet that has a few rows like the one on the left. But I want my output to be the right side table. That is, where there are duplicate values, I need to display the max(date) and the corresponding user alone.
How can I do this?
Thanks,
2 answers
Hi Radi,
Check the Screenshot and attached.
I created two calculations. First one to find Maximum Date and the second one to compare Last date to Max date and filter in the TRUE.
Dragged Calculation 2 to Filter and selected TRUE.
Hope it Helps!!!
Let me know
Thanks
Deepak
