• Tchang Su
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies

Dear all,

 

I created a multi select picklist with different countries and I chose for each people I created the countries he works with.

 

In my report, I have this result for example :

FR               2

FR, GB       1

GB              3

GB, USA    1

USA            1

 

I want to count each value and to have just one line for each country :

FR   3

GB   5

USA  2

 

How can I do to separate the picklist values ?

Do you have any suggestion for this pb ?

Thank you.

 

:smileyhappy:

Dear all,

 

I created a multi select picklist with different countries and I chose for each people I created the countries he works with.

 

In my report, I have this result for example :

FR               2

FR, GB       1

GB              3

GB, USA    1

USA            1

 

I want to count each value and to have just one line for each country :

FR   3

GB   5

USA  2

 

How can I do to separate the picklist values ?

Do you have any suggestion for this pb ?

Thank you.

 

:smileyhappy: