This content has been marked as final. Show 5 replies
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.
Try this,1 person found this helpful
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
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 .
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.