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
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
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.
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
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.