I have one scenario like I have one week list box which I always selected one value. I have one Pivot table in which is some thing like as below
Listbox:
w1
w2
w3
w4
w5
w6
w7
Pivot table:
Dim1
Dim2
Expr1
w1
1
AAA
95
2
BB
100
3
CC
2
4
DD
1
If I select another week in the same listbox, week should be appear beside of default selected week and the values should be populated as dynamically.the selected week should be subtract with default selected week. result as below
Dim1
Dim2
Expr1
w1
w2
1
AAA
95
95
2
BB
100
98
3
CC
2
26
4
DD
1
78
please let me know your suggestions for better approach.
note: w2 values are dummy values and also I don't have sample data.
