I created a field that allow multiple values. The second field is also multiple values which lookup from the first field.
I want to display the value of the second field categorized in a statistical view as the following:
For eg:
First field contains value: a,b
Second field contains value: c,d
The view shall display:
column 1 column 2
c
a
d
b
but I got this in my view.
column 1 column 2
c
a
b
d
a
b
Thanks in advance.
Subject: Problem in displaying multiple values in view
in your first column make the formula: field2 + "" + field1
sort and categorise the column, you should get what you want.
from designer help:
Adding subcategories to an All by Category view
In your Furniture Catalog database, you want to add subcategories, indented under the main categories, to make documents easier to find in the All by Category view. Subcategories are indented under main categories automatically in a categorized column. You can have 32 levels of subcategories.
The Categories field of the Furniture Description form is an editable choice list field with the following entries:
Bedroom
Kitchen
Living Room
To add subcategories, rewrite the choice list choices as follows, update existing documents, and refresh the view. A backslash ( \ ) after a main entry denotes the subcategory name.
Bedroom\Beds
Bedroom\Dressers
Kitchen\Tables
Kitchen\Chairs
Living Room\Sofas
Living Room\Tables
Recategorize the documents that already exist to assign them to one of the subcategories. You can do this manually by choosing Actions - Categorize, and then typing the full subcategory specification (Bedroom\Beds) into the Categories dialog box. If there are many documents, create agents that set the new values for the Categories field of each document.
Press SHIFT+F9 to rebuild the view index so documents display with their new subcategory names.
Subject: RE: Problem in displaying multiple values in view
thanks it works fine.