How do I avoid duplicate values for a column in a specific data slice?
I’m sure this should be simple but I cannot find how to do it! I have a table “Tenancy Application” with multiple columns but the significant columns for this query are [TenancyAppID], [Tenant] and [TenancyYear].
I want a data slice that includes all columns but only displays a single occurrence of [Tenant] values. Reason being a [Tenant] could occur on one or more row due to having different [TenancyYear] value.
What do I need to add to following filter expression to achieve this?
(It would also be a bonus if I could sort the records alphabetically at the same time, although I appreciate that I can do this with my selected views)