Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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