https://communities.sas.com/t5/SAS-Visual-Analytics/Use-filter-box-in-data-plan/m-p/852212#M16794 <P>I have a dataframe that has been transposed in such a way that the measure groups are across the top (activity dates) and the records trail vertically (record 1 goes A1-A10, instead of A1-J1).&nbsp; The transpose occurs in the data plan.&nbsp;</P><P>As such, when this is input into a Visual Analytics list table, VA thinks the records are still horizontal, so any filtering slices across all records, instead of selecting a single or several whole records.&nbsp; I need a way to filter the records so that selecting a drop down refilters which vertical records appear in the list table.</P><P>Is there any to, after selecting a value in a filter box, to reactivate the data plan and have the refiltered record appear in the list table?&nbsp; I understand that this is a tall order, but the data has to appear a very particular way and I couldn't think of a way to do the filtering.</P> Thu, 05 Jan 2023 00:28:59 GMT ahawkins61 2023-01-05T00:28:59Z https://communities.sas.com/t5/SAS-Visual-Analytics/Use-filter-box-in-data-plan/m-p/852212#M16794 <P>I have a dataframe that has been transposed in such a way that the measure groups are across the top (activity dates) and the records trail vertically (record 1 goes A1-A10, instead of A1-J1).&nbsp; The transpose occurs in the data plan.&nbsp;</P><P>As such, when this is input into a Visual Analytics list table, VA thinks the records are still horizontal, so any filtering slices across all records, instead of selecting a single or several whole records.&nbsp; I need a way to filter the records so that selecting a drop down refilters which vertical records appear in the list table.</P><P>Is there any to, after selecting a value in a filter box, to reactivate the data plan and have the refiltered record appear in the list table?&nbsp; I understand that this is a tall order, but the data has to appear a very particular way and I couldn't think of a way to do the filtering.</P> Thu, 05 Jan 2023 00:28:59 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Use-filter-box-in-data-plan/m-p/852212#M16794 ahawkins61 2023-01-05T00:28:59Z