Interface - Drop down - Filter

[tmathey]

hi,

I am trying something that should be simple but I cannot figure what I am getting wrong. I want to mimic an Excel-based pivot table behaviour using a drop-down list. The user should be able to choose a value (LE in the example) which will then filter the remaining table data. The drop-down list does not show the LE values as expected. I am not sure what I am missing. 

Thanks!

[kelsey_kincaid · Accepted solution]

Hi @tmathey , you can use a cross tab to make your LE values into field names, then connect that to your drop down tool. From there you can configure it to use the fields from the connected tool. Let me know if this works for you!

[tmathey]

many thanks @kelsey_kincaid! this solved my issue.