I have Column A, Column B and Column C with Yes and No data. I want to use this 3 column to create a multi selection filter. For example, if I select Column A, then the data only show the data which is Yes in Column A. If I select Column A and Column B, my data only show the Yes data either in Column A or B.
Column AColumn BColumn CYesYesNoNoNoNoNoNoYesYesYesYes
I tried to use parameter and it only allow me to select one column at a time. Appreciate if someone could provide some help.
답변 5개
Right now it seems pivoting those fields seem the only way out because that is the only way you can reference those field name in a calculated field.
