This discussion is archived
5 Replies Latest reply: Jun 23, 2011 5:45 AM by user137887 RSS

grouping column values

870550 Newbie
Currently Being Moderated
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
    Sablok Explorer
    Currently Being Moderated
    Hi,

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

    Thanks & Regards
    Sablok


    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
    870550 Newbie
    Currently Being Moderated
    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
    user137887 Explorer
    Currently Being Moderated
    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
    870550 Newbie
    Currently Being Moderated
    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
    user137887 Explorer
    Currently Being Moderated
    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'
    end

    This should work.

    Cheers !!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points