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). The transpose occurs in the data plan.
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. I need a way to filter the records so that selecting a drop down refilters which vertical records appear in the list table.
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? 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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.