Hello,
I have following query.
Field1 : = " Company1 (ABC); Company2 (ABC); Company3 (XYZ); – ABC --; Company4 (CDE)"
I want to create a view, which will have sort on first column which will only show the Distribution channel as ABC or CDE, XYZ.
Second column should show only the company listed under the specific Distribution channel.
It should be like
ABC
Company1
Company2
XYZ
Company3
CDE
Company4
Can anyone guide me how to achieve this?
MS
Subject: View
The short answer is you can’t. With all of that in one field on one document there is no way to get it separated like you want. Since all the data is in one field on one document, even if you manage to get the distribution channels to show up as categories you are going to have every company listed underneath every distribution channel.
A better solution would be one document per company/distribution channel pair, and then you could categorize the information. As it is there isn’t any way to split it in such a way that the categories are going to work.
– Charles
Subject: RE: View
Thanks for your reply. I also thaugth so, but wanted to take the second opinion.
MS