4 Replies Latest reply on Jun 25, 2012 5:36 AM by William Ohara

    Mutiple fields into single filter box

    William Ohara

      hello need help using a two fields into a single filter

        • 1. Re: Mutiple fields into single filter box
          Russell Christopher

          Hi William -

           

          I'll take a swing at this but I'm not 100% sure I understand what you need and why - maybe you can give us a little bit more context?

           

          Anyhow, let's say you have two dimensions: [Customer Name] and [Product Category].  Based on what you're trying to do, you could do one of two things:

           

          • In the Dimensions list, SHIFT-CLICK both fields so they are selected, then right-click either one and choose Create Set. The Create Set dialog will appear and you can give it whatever name you want. Use the SET as a filter.
          • Create a new Calculated Field: [Customer Name] + " " + [Product Category] Use this new field in your filter.

           

          Good luck! Let us know if you need more!

          • 2. Re: Mutiple fields into single filter box
            William Ohara

            Thanks for the reply:

             

            I have 2 fields Modifier1 and Modifier2...these fields can either contain TC,26 or GL.  I want to create one filter that will dislapy all rows that either modifier1 or modifier2 have TC in them or 26 or GL:

             

            Row    Modifier1 Modifier2

              1        26               TC

              2       TC               GL

              3        GL               26

             

            So if able to create one filter on both of these fields and filtered to rows containing 26 then it would grab row 1 and 3.

             

            Hope this helps.

             

            Thanks

             

            Bill

            • 3. Re: Mutiple fields into single filter box
              Russell Christopher

              Here you go (see attached)

               

              • Create a parameter which includes potential modifier values
              • Create a calculated field which compares Mod1 and Mod2 to the value selected in the parameter. Return True or False based on matching/non-matching
              • Use calculated field as a filter
              • 4. Re: Mutiple fields into single filter box
                William Ohara

                Danka...thanks for the quick response...

                 

                Bill