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.
... View more