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

# grouping column values

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
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
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
Currently Being Moderated
Try this,

Let's say your picklist is call type then

Click on fx on column
Click Bin Tab
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
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
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