Friends need your help please..
I am simple trying to put on a Text Table object.
I have 3 columns City, Interface, Speed. In all the Cities I have the same interfaces (Approximately 6) But I want to list specific interfaces based on City names.
Please look at the sample data I have prepared..
I have same interfaces in both Denver and London. But I want to show the table as below..
I tried to put on a multi drop down list for Interface and I selected Interface 2 and Interface 5 but I am getting a result like below
I have to achieve the requirement somehow with your help. Need your advices please.
I have attached sample spreadsheets for data and result
One option you could use would be to create a combined field.
Highlight the city and interface fields in your data pane, right click and select 'Combine fields'.
This would allow you to filter based on values such as 'Denver, Interface 2' and 'London, Interface 5' as a concatenated value.