Pivot table selection issue

[#1]

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

[Digvijay_Singh]

I know stalwar1 will conclude on my bug or QV bug

[Kushal_Chawda]

Sunny bhai iska koi easy solution batao

[sunny_talwar]

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

[sasiparupudi1]

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

];