Group items in a dimension table

[#1]

Hi

I have a dimension table in my script and I want to group the data items so if i have:

Expense AE

Expense AA

Expense AC

These should appear in Expense A

[its_anandrjs]

this are the fields or the table names

[#3]

these data lines in a table. 

[its_anandrjs]

Write like for new field type

if( Match(Yourfieldname,'Expense AE','Expense AA','Expense AC'),'Expense A','Other') as NewFieldtype

[#5]

is this in the script?

[its_anandrjs]

Yes in the load script like

if( Match(Yourfieldname,'Expense AE','Expense AA','Expense AC'),'Expense A','Other') as NewFieldtype

and in dimension or expression

=if( Match(Yourfieldname,'Expense AE','Expense AA','Expense AC'),'Expense A','Other')

[#7]

ok thanks.

What about if i have many to of this so as above but also Expense AB, Expense AF AS Expense C

[its_anandrjs]

If possible provide some sample data for this.

[#9]

LocalPointOfDelivery	LocalPointOfDeliveryDescription	Category
A&E	A&E	AE
All	All	AL
ATFAO	Attended Outpatients - first attendance	ATFAO
ATFUO	Attended Outpatients - follow up	ATFUO
ATOP	Outpatient Attendances excl DNA	ATOP
CC	Critical Care	AL
COM	Community	AL
DA	Direct Access	DIR
DC	Daycase	DC
ELIP	Elective Inpatient	EIP
IP	All in-patients	IP
NEL	Non Elective Inpatient	NEIP
OP	Outpatient Attendance	OP
OPFA	Outpatients FA	ATFAO
OPFU	Outpatients FU	ATFUO
OTH	Other	AL
WA	Ward attenders	OP

So in the above

I want AFAO, AFTUO to be under Out, and the all others as they are.  This will then want to be be in a list object as a filter.

[its_anandrjs]

In which column that is Category