Hello folks,
I know that one of the solutions for this is to use Power Pivot and Parameters but my column for filtering consists of alphanumerical characters so this option is not available and it is too slow.
Therefore, I have created connection to teradata with SQL code and in WHERE clause I have some conditions.
Now, my question is: is it possible to build/create with Form Controls/ActiveX Controls something like a drop down list where on selected item it would import new set of data from teradata.
Picture below.
Thank you in advance.
I know that one of the solutions for this is to use Power Pivot and Parameters but my column for filtering consists of alphanumerical characters so this option is not available and it is too slow.
Therefore, I have created connection to teradata with SQL code and in WHERE clause I have some conditions.
Now, my question is: is it possible to build/create with Form Controls/ActiveX Controls something like a drop down list where on selected item it would import new set of data from teradata.
Picture below.
Thank you in advance.