8 Replies Latest reply: Dec 1, 2017 11:48 AM by Quy Nguyen RSS

    Combining two columns in one filter?

    Peter Viberg

      Hi,

       

      I have a little problem with filtering that I hope you can help me with.

       

      OriginalSplit
      OriginalSplit
      OriginalSplit
      Original
      Split
      OriginalSplit

       

      All rows are tagged like above. It means that if both "Original" and "Split" columns have a value, that row should always be selected regardless of this specific filter.

       

      If only Original column has a value, then I would like rows with values in both "Original" and "Split" + rows with values in Original column to be shown when "ORIGINAL" is selected in a filter.

      If only Split column has a value, I would like rows with value in both "Original" and "Split" + rows with values in Split column to be shown when "SPLIT" is selected in a filter.

       

      So the filter should look like:

       

      Original or split?
      Original
      Split

       

      This of course could be done my concatenating the two columns, but then I would have to select two of the three concatenated values "OriginalSplit", "Original" and "Split" - and this will be confusing to the user. So I want it to be just two options.

       

      Any ideas how to do this?

       

      Thanks a lot!

       

      //P