Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have pivot table like below with 3 measure and one dimension
Measure | Dim | D1 | D11 | D12 | D2 | D21 | D22 |
M1 | 42 | 39 | 24 | 44 | 47 | 48 | |
M2 | 21 | 47 | 39 | 16 | 17 | 30 | |
M3 | 19 | 31 | 21 | 33 | 29 | 26 |
Now requirement is like,
when I select the D1, I just want to see D11,D12
when I select the D2, I just want to see D21,D22
Bydefault, I just want to see D1, D2
I know stalwar1 will conclude on my bug or QV bug
Sunny bhai iska koi easy solution batao
Yaar leaving for work, I will go through this and see if I can offer anything better than what you already have . If not, then call our guru
Have a mapping table between the dimension values
t1:
Load * Inline
[
Dim,M1,M2,M3
D1,20,30,40
D11,21,23,45
D2,44,16,33
D12,30,12,23
D21,47,17,29
D22,47,17,29
];
t2:
load * Inline
[
NewDim,Dim
D1,D11
D1,D12
D2,D21
D2,D22
];