I have a dynamic spreadsheet table working appropriately. My intent was to create a selector that would be tied to this table, showing only the information I am looking for. For example: I choose option X in this selector, and the table showing only X and its data appears.
Is this even possible with this program? My research is leading me to think no, as I cannot come up with a workable solution, nor is the help file really giving me a good direction. The Excel model is set up correctly, and I had assumed that all I would need to do is link the selector to the variable that changes in the Excel model, with the display data being, well, the data table.
Is there a step I missing here?
Thanks!
Matt