Hi @Ananth
Please find below the link for tables using dataset parameters.
https://dm4j7qn6bn5ut.cloudfront.net/qs-tips-tricks/index.html?dashboard=fb35f128-9091-4055-baf0-9563909cddea&sheet-sheet&account=newfeature
For multiselect, I followed the below community solution:
https://community.amazonquicksight.com/t/how-can-i-select-multiple-lines-from-a-table-and-how-could-i-then-deselect-those-items-to-exclude-them-form-the-analysis/1217/6
Here the maximum number of fields that you can select cannot change but based on the selection you make on the left table, only the relevant number of fields get populated in the order of selection. Though this is based on direct query, you can modify it for SPICE as well.
Please let me know if this end solution works for you. If so, I can share the detailed steps.
Regards,
Vetri