Display unique value in Cascading Filter

[Amrit Kumar Pal]

I am creating a Cascading Filter, on selecting the Region, it is fetching all the matching 'State' records of that Region.

But i want only unique States to show in the list instead of multiple/duplicate states of that Region.

How can i achieve to get unique State values only?

Picture attached as attachment.

[Community Alums]

Hi @Amrit Kumar Pal ,

Filters are designed to work on tables with a unique value.  To get that to work as-is, you would need a custom filter. Alternatively, you could use the hierarchy to get the locations that are states (city is empty and state is not).  Then get the locations that match, then go to the next level in the cascade.

Referred from this thread which is a correct answer.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Amrit Kumar Pal]

I have no idea about Custom Filter.

Still unable to resolve the issue.