I am trying to make different filter group from from column.
For example, if i have values
Field contain values = A, B, C , D, E, F, G H
filter1 = ABC
filter2 = DE
filter3 = FGH
Is it possible from one field to show different filter with name.
WHEN I AM TRYING TO SELECT D, E from filter then ITS ALSO SHOW ALL OTHER VALUES. I don't want all values i only want certain value in filter drop-down.
Hi Jhon Smith,
Did you try creating a calculated field like this?
If [Letter] = "A" then "ABC"
ELSEIF [Letter] = "B" then "ABC"
ELSEIF [Letter] = "C" then "ABC"
ELSEIF [Letter] = "D" then "DE"
ELSEIF [Letter] = "E" then "DE"
And using the field as your filter?