I have a table chart in my app that that has multiple records with the same primary key but with different dates. So it might look like this:
I would like to only display the record with the latest (most recent) date.
Is there a way to do that within the table properties?
Solved! Go to Solution.
I'm not really good with set analysis. I was hoping for something easier. I tried the dimension on the key field and max(your date field). That gives me the latest date. But I failed to mention that there are multiple primary key records, like this:
So, for each primary key I need the latest date. Sorry for not explaining that.