5 Replies Latest reply: Jun 23, 2011 7:45 AM by user137887 RSS

    grouping column values

      Is there any column formula, where you can group three or more values and give a new name ?
      ie - if the picklist values are a,b,c,d,e,f
      then i would like to display as x and y , where x comprises of a,b,c and y includes d,e,f.. Kindly let me know if any formulas available
        • 1. Re: grouping column values

          You can use the option "New Calculated Item" in the pivot table to attain your requirement.

          Thanks & Regards

          Sorry it can not combine values from two different picklist

          Edited by: Sablok on Jun 22, 2011 3:28 PM
          • 2. Re: grouping column values
            but the values in the new calculated item correspond to that particular field alone.. I want to combine 2 picklist. So i want the values in the new calculated item to display the values from both the picklists.
            • 3. Re: grouping column values
              Try this,

              Let's say your picklist is call type then

              Click on fx on column
              Click Bin Tab
              Add Bin
              it will ask to for value, enter a and add b add c and click OK
              When it prompts for Bin Name provide x there.

              Do the same for Y options.

              This will group all a,b,c together and display them as x

              hope this solves your problem
              • 4. Re: grouping column values
                Hi ! the Bin option was good. Thanks for your reply. But it includes values from only one field. Is there any option to combine values from two picklist .
                • 5. Re: grouping column values
                  This option is also based on Bin concept, but since you want 2 fields, u will have to code it.

                  Click Fx of the column
                  case WHEN Field1 in ('a','b','c') then 'x'
                  case when Field2 in ('g','h','i') then 'y'
                  else 'some default value'

                  This should work.

                  Cheers !!!