Hi,
I have an array of checkboxes that I need to filter by column based on the answers to a previous multiple choice question. More concretely, I have types of cancer on the y-axis and family members on the x-axis; I'd only like to show the family members that have been previously checked as having cancer in the array.
I cannot use the regular filtering option (which works by rows) because there are too many types of cancer to comfortably fit on the x-axis.
I cannot use the workaround for filtering an array by column because I need checkboxes (multiple choices), not radiobuttons (single choices).
Any suggestions would be greatly appreciated!
Thank you,
Cristina