RE: A view sorting question Stan Rogers 25.Jun.12 08:05 AM a Web browser Domino Designer All ReleasesAll Platforms
What you're describing can't really be done in a view with the documents you have. You need the documents to be "aware" of which category they're in when they're being displayed (most of the documents are going to appear in more than one category, and you only want the value that corresponds to the category).
To make this happen in a view, you would need to run an agent to create a new set of documents from your questionnaire documents, one per software title per customer. Remember, a view isn't a report; in order to make it act like one, you need to provide it with a document set that follows your report structure.
The alternative is to run a report. You can use an agent to create a document containing the data you want in a table in a rich text field, you can create an HTML document on demand, you can write an Excel or OpenOffice.org/Symphony spreadsheet, etc. The one thing you can't do is create a view that looks the way you want using the documents you have now.