Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacob
Contributor III
Contributor III

How to Group Dimension In Pivot table

Hi ALL,

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

Dim1 is inline table which i have created

Eg.

Dim1DimValue1Value2
Custome GroupA101
 B202
 C303
 D404
 E505
 F606
 G707
 H808
 I909
 J10010
 K11011

 

I want to create group like below

Dim1DimValue1Value2
Custome GroupD404
 E505
 F606
 G707
 H808

 

Labels (2)
1 Reply
vsr_shimla
Contributor II
Contributor II

 

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