How to Group Dimension In Pivot table

[Jacob]

Hi ALL,

I want to Create group of dimension form existing dimension filed.

Dim1 is inline table which i have created

Eg.

Dim1	Dim	Value1	Value2
Custome Group	A	10	1
	B	20	2
	C	30	3
	D	40	4
	E	50	5
	F	60	6
	G	70	7
	H	80	8
	I	90	9
	J	100	10
	K	110	11

I want to create group like below

Dim1	Dim	Value1	Value2
Custome Group	D	40	4
	E	50	5
	F	60	6
	G	70	7
	H	80	8

any one can help

[Lisa_P]

[Table]:
LOAD * INLINE
[
Dim,Value1,Value2
A,10,1
B,20,2
C,30,3
D,40,4
E,50,5
F,60,6
G,70,7
H,80,8
I,90,9
J,100,10
K,110,11
](delimiter is ',');

Left Join
Load 'Custom group' as Dim1,
Dim,
Value1,
Value2
resident Table
where Dim = 'D' or Dim= 'E' or Dim = 'F' or Dim= 'G' or Dim= 'H';