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

[vsr_shimla]

Load an Inline table and give a name to your customer groups

CustomerGroup:
Load * Inline [
Dim2,CustomerGroup
A, Group1
B,Group1
C,Group1
D,Group2
E,Group2
F,Group2
G,Group2
H,Group2
I,Group3
J,Group3
K,Group3

];

Hope it solves your prob,

rgds