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 respuestas
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.
