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:
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.