Is there any way to filter the data in a pick list to only display unique values?
I have data in Excel I would like to import to HEAT as is without any customisation. The document consists of 5 columns of data and roughly 1300 lines. It's a process tree structure where the A column consists of our top 11 processes and column B, C, D and E are sub processes and sub sub processes for each top process, and so on. In Excel it's easy to add filtering and filter just one top process in column A, filter one sub process in column B and so on.
My thought was to set this up as five drop downs where you could do the filtering in HEAT. But importing it straight up would mean the first top drop down would have all values from column A, roughly 1300. Here I only want to display the unique values.
I'm going to use an existing business object and cannot make any changes to it, I can only play with the pick list.
Is there a possibility to use constraints and expressions?